Question Re: Salesforce.com - Database Connector Error: 'Unexpected' in Technology Q&A

Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 17:27:28 GMT

Just recently I have been encountering this issue with Crystal Reports 2011. Once I enter my login information, I can see my instance in Salesforce, but once I click to expand (to see the Tables and Stored Procedures), I receive the error "Database Connector Error: 'Unexpected' ".

I am the administrator of our Salesforce instance so I have access to EVERYTHING in Salesforce, and I have had other users try to login and it works for them (with less access). I have a feeling I have access to a report or a table that causes Crystal Reports to send this unexpected error.

Also, when connecting to Salesforce with Crystal Reports XI, it works fine with my account.

Is there a log file somewhere that I can see exactly what causes this to fail? I've been on this for two days and am starting to go crazy!

Any help would be appreciated.

Re: Salesforce.com - Database Connector Error: 'Unexpected'

former_member11696 — Thu, 23 Jun 2011 19:40:25 GMT

Hello,

According to our Database Connectivity Excel file it should connect natively. I'll have to check with the team to see if there are any known issues...

In the mean time have you downloaded SP1?

https://smpdl.sap-ag.de/~sapidp/012002523100007683092011E/cr2011sp1.exe

Thank you

Don

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 19:42:07 GMT

Sorry, I should have mentioned that I did download SP1 to no avail. I've also tried on different computers and same issue.

Re: Salesforce.com - Database Connector Error: 'Unexpected'

former_member11696 — Thu, 23 Jun 2011 19:51:43 GMT

Hi Again,

Just verified it does work. So, is this a new computer you are using? If so you need to log in and add it to the trusted list.

Are you going through a Proxy server? If so you need to edit the XML file located here:

C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java

and add your Proxy info.

Try SP 1 also.

Thanks

Don

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 19:57:15 GMT

I've been using this server for a few months and everything was working perfectly, even when i upgraded to 2011. It was just earlier this week that I started getting this error, without changing anything on the server side.

CR2011SP1 login with admin user account = Database Connector Error: 'Unexpected' (login is successful, just can't access tables)

CR2011SP1 login with regular user account = no problems

CRXI login with admin user account = no problems

No proxy server, 2011SP1 installed, heap size set to 512 in CRConfig file.

Re: Salesforce.com - Database Connector Error: 'Unexpected'

former_member11696 — Thu, 23 Jun 2011 20:31:48 GMT

Vitaly is our Salesforce.com support Rep and has an account so I asked him to help also.

Do you have a c: emp folder? If so and you are not on windows XP can you rename it to c:MYTemp and try again?

CR should ship a database logging dll - search for this kbase article:

[SAP Note 1553469 - How to enable Database logging in Crystal Reports for Visual Studio 2010|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333533353333333433363339%7D.do]

Follow the instructions and see if you get a log file. It may tell us what if failing with more detail.

Don

Re: Salesforce.com - Database Connector Error: 'Unexpected'

vitaly_izmaylov — Thu, 23 Jun 2011 20:34:24 GMT

It could be a number of objects causing the problem. Few options here:

I. Filter table list

1. Open Crystal Reports

2. Go to File/Options, Database tab

3. Uncheck stored Procedures or set filter Table name LIKE A%

4. Close and restart Crystal Reports

5. Test the connection again

The test above will verify if any of the objects causing the problem.

II. Try Add command connection

1. Open Crystal Reports

2. Establish SalesForce Connection in Database Expert

3. Click add Command

4. You can add a simple SOQL statement like:

SELECT Id FROM Account

5. Click OK and test the report

It could be a number of objects, it could be Custom object with unsupported characters in Object name, etc.

Please test and update the thread

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 20:55:39 GMT

Thanks for your input Vitaly, it is much appreciated.

I tried "Filter table list" exactly as you wrote and I still received the error. What type of characters should I be on the lookout for? I looked through our list of custom objects and they all have text or numbers only, no special characters.

I also tried adding a command connection, and that worked fine.

Thanks

Alex

Re: Salesforce.com - Database Connector Error: 'Unexpected'

vitaly_izmaylov — Thu, 23 Jun 2011 21:25:40 GMT

Alex,

There is a small chance that table starting with "A" character causes the problem. Please try to filter with "B%" or "C%"

I will test if there is a registry key in CR 2011 to limit number of objects in Database Expert

You can also try to uncheck Table and check Stored Procedures to verify if you see them.

Vitaly

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 21:32:33 GMT

Hi Don,

I was able to get the log files working. I looked through it quickly and didn't see anything obvious, but here is some of it

TIMESTAMP THREAD_ID FILENAME LINE_NUMBER LOGGED_DATA LEVEL

2011-6-23-17-14-2 3396 ..\cserrinf.cpp 523 Error 14722 (..\csdll.cpp, 117): : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32_res_xx.dll 1

2011-6-23-17-14-9 3396 .\QESession.cpp 445 Set Product View Locale: 1033 20

2011-6-23-17-14-9 3396 .\QESession.cpp 479 Set Preferred View Locale: 1033 20

2011-6-23-17-14-9 3396 .\QESession.cpp 501 Set Process Locale: 1033 20

2011-6-23-17-14-9 3396 .\qecommon.cpp 117 This property is currently in a read-only state and cannot be modified. File Name: ".\QEProperty.cpp". Line: 217 1

2011-6-23-17-14-12 3396 .\crdb_sforce.cpp 194 Leaving DbInitialize() 20

2011-6-23-17-14-22 3396 .\crdb_sforce.cpp 803 In DbFetchTableList() 20

2011-6-23-17-14-25 3396 .\crdb_sforce.cpp 866 The ErrorArray exception thrown from the function DbFetchTableList() 1

2011-6-23-17-14-25 3396 .\crdb_sforce.cpp 2567 In DbFreeErrorInfo() 20

2011-6-23-17-14-25 3396 .\crdb_sforce.cpp 2570 Leaving DbFreeErrorInfo() 20

2011-6-23-17-14-25 3396 ..\cserrinf.cpp 523 Error 31810 (..\..\src\data\queryenghelp.cpp, 554): Database Connector Error: 'Unexpected': Unexpected 1

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 21:37:58 GMT

Vitaly,

I tried restricting to B%, C%, M%, etc to no avail. I also tried unchecking Tables and only selecting Stored Procedures and we always end up with the same error.

Let me know what you find.

Alex

Re: Salesforce.com - Database Connector Error: 'Unexpected'

former_member11696 — Thu, 23 Jun 2011 21:51:49 GMT

The language reference dll - crw32_res_xx.dll - is always listed so nothing there but the rest is very helpful...

Anything more after the last line you posted?

Thanks again

Don

Re: Salesforce.com - Database Connector Error: 'Unexpected'

former_member11696 — Thu, 23 Jun 2011 21:54:54 GMT

Can you select just tables and limit it to just B%?

Don

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 23 Jun 2011 21:57:55 GMT

Selected Tables Only and B% - same error.

Here's the full log file: http://www.4shared.com/file/zj4JDJUT/crw32_3396_2011-6-23-17-14-2_r.html

Re: Salesforce.com - Database Connector Error: 'Unexpected'

vitaly_izmaylov — Thu, 23 Jun 2011 23:22:54 GMT

Alex,

If you know how to change value in the registry then you can try to limit number of objects you can see in Database Expert.

By default the number is 8000

The registry key is:

HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions

Try to set number for "NTablesMax" to 500

Close and restart Crystal Reports to see if it makes any difference.

Vitaly

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Fri, 24 Jun 2011 02:50:18 GMT

I changed "NTablesMax" to 500 in the registry and same issue.Also tried switching between Tables only (with and without A%, B%, etc) and stored procedures and unfortunately, same issue.

Re: Salesforce.com - Database Connector Error: 'Unexpected'

vitaly_izmaylov — Fri, 24 Jun 2011 14:58:37 GMT

I would review a list of recently added objects for the subject of suspiciois characters in the object name or the name length.

If any table name looks suspicious, then you can use "Add command" option to verify it CR able to handle it.

I would also verify newly added SalesForce.com reports (stored procedures).

Note, Crystal Reports XI supported low versions of SalesForce.com API (9 and 13). The SP3 for Crystal Reports 2008 supports API 16 , recently released CR 2008 SP4 supports API 20. One of the major differences is custom objects support. Some of the custom objects are not visible at all in the earliest versions of API. So it makes sense why CR XI works.

You may try to test it in different SP of CR 2008 as well.

Vitaly

Re: Salesforce.com - Database Connector Error: 'Unexpected'

Former Member — Thu, 14 Jul 2011 15:18:43 GMT

Solution:

Increase the value for JVMMaxHeap from default 64 000 000 to 512 000 000

In CRConfig.xml file located here:

C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java

or for Windows 7 64-bit:

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java

Restart Crystal Reports and test the connection.

Re: Salesforce.com - Database Connector Error: 'Unexpected'

vitaly_izmaylov — Thu, 14 Jul 2011 15:24:57 GMT

Thank you, Alex, for updating forum with the solution.