Connector Error: An error occurred while parsing the native salesforce report

[angelica_mariscal]

Hi,

I have crystal reports 2011 which connects to sf.com reports. I do not have an issue if i pull tables down to crystal, but when i use stored procedures, crystal stops working and shuts down. When i had the 2008 version, this did not occur. What doesn't make sense is that old reports that used stored procedures in crystal still work fine, but when i make any changes to that report, it no longer works.

• I have SP2 Patch 8 and 2 installed
• registry editied Reports\Database\ODBC\

          "AccessMode" as a Reg_DWORD 0x00000000 (0)

• JAR files replaced per http://search.sap.com/notes?id=0001639310&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...
• In CRConfig.xml - Heap increased  <JVMMaxHeap>512000000</JVMMaxHeap>

Not sure what else i can do? If it's a DateTime field issue, how is this fixed?  I know i do not have more than 8,000 stored procedures, so it's not a space issue.

[vitaly_izmaylov]

Not sure what  "SP2 Patch 8 and 2 installed" means.

Does it mean you tested on two diffrent machines with SP02 Patch 8 and SP02 Patch 2 ?

I do not believe the registry entry you mentioned has anything to do with SFDC connectivity

The JAR files issue fixed in SP02 Patch 10. If you below that level then you should have manual files replacement.

Heap size increase is one of recomended best practises

So far I do not see any problems in your configuration. Potentially I see the following reasons:

- the Stored Procedure has been modified

- the SFDC API level does match

- Something is not configured on local machine: wrong jar files or CRConfig.xml missing some items

- username right permissions on SFDC

Do you still have CR 2008? Can you compare CRConfig.xml from CR 2008 with CR 2011 one?

Can you create a new report in SFDC using your username and then test it in CR 2011?

[angelica_mariscal]

I first installed SP2 Patch 2 to fix one problem then later on had to install SP2 Patch 8 for another issue i was having.  If i updated the JAR files, do i still have to run the SP02 Patch 10? If so, do you have the link to this patch? 

Yes, the Stored Procedure has been modifies. Why would that cause an issue? I verify database, fields are updated. But the refresh is what freezes the and crashes crystal

What do you mean by SFDC API level?

All permissions are fine.

Thanks.