Issues in running crystal reports 2013 with SOQL as a datasource

[Former Member]

Hi Experts,

We have some crystal reports created in CR 2008 with command as a data source and all the commands are written in SOQL pulling data from SFDC, now when I open and run those reports in crystal report designer 2013 it is giving below errors:

--------------

Failed to retrieve data from the database.
Details: 42S22:[Simba][SQLEngine] (31400) Qualified column could not be bound: c.Investor__r.Relationship_Formula__c. [Database Vendor Code: 31400 ]

------------

Failed to retrieve data from the database.

Details: 42S22:[Simba][SQLEngine] (31400) Qualified column could not be bound: k.Account_Relationship__r.PE_Priority__c. [Database Vendor Code: 31400 ]

------------

We are running crystal reports in both the version with system admin user who has access to all the objects in SFDC. It works well for CR 2008 but not for CR 2013, means relationship is not an issue.

We have done some analysis and found that if the field in query contains two periods (.) it is not recognising that field, if we remove that field from query, CR 2013 takes that as a valid statement.

Any help or suggestions on this issue would be a great help.

Regards,

Apoorv

[Former Member · Accepted solution]

Hi,

You can first open and update the connection in cr 2013 designer..

Database -> set datasource location -> update the connection here . You can find the error easily.

The report works in cr 2008 but not in cr 2013 i am wondering this could be the problem..No Please provide you are getting the error details.

Thanks,

DJ

[Former Member · Accepted solution]

Hi DJ,

When I am trying to follow the steps mentioned above, I am getting similar error:

Failed to retrieve data from the database.

Details: 42S22:[Simba][SQLEngine] (31400) Qualified column
could not be bound: a.BRK__c. [Database Vendor Code: 31400 ]

Thanks

Apoorv

[former_member183750 · Accepted solution]

Hi Apporv

Please check your database documentation for error 31400.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

Hi Ludek,

I could not find any documentation related to error 31400.

Please can someone advise what could be the issue as the same query works fine in Salesforce developer console and also in Crystal Reports 2008 but not in Crystal Reports 2013.

Thanks

Apoorv

[former_member183750 · Accepted solution]

Hi Apoor

Note the error: Database Vendor Code: 31400

This means that the error number is passed directly from the DB client through the report engine, completely unaltered. There is no way for me to tell what the error number is. See if googling 'Database Vendor Code: 31400' will help.

- Ludek

[vitaly_izmaylov · Accepted solution]

It is probably late, but I want to post possible solution in this thread:

2118506 - Crystal Reports Error: "Failed to retrieve data from
the database. Qualified column could n...