Unterminated String Constant when using BDC Webparts

Question

Hello,

I've imported an application to use with BDC.

Trust Delagation enabled, permissions set. On my server I am able to get to a stage where there is some sort of connection, however the result is "There are no items to show".

There is a Javascript error which may be throwing this off. I've reset the site to use the default.master template in case there is a fault with my own, but have no joy.

Error is: Unterminated String Constant.

 

Does anyone know why this is happening or if there is a fix?

Thank you!

Uzma

Answer 1

OK - here's the deal.

I can connect sucessfully to the CRM data using my SharePoint admin account only on my MOSS server.

When I log out of the server and go to the site which has CRM data, I get "Unable to connec to CRM data".

This is the ONLY account which can retrieve data, I've tested my own account on the box and despite being a farm administrator, I have the same above problem.

In summary

MOSS Admin account has been given CRM permissions to be members of teams and read data

MOSS Server

1) MOSS Admin account can log into List Web Part for CRM 4.0 and view information.

2) MOSS Admin account can log view BDC Data List Webpart and account details given.

3) I cannot log in as myself and view any data, have unable to connect to CRM data

Client PC

MOSS Admin Account cannot log into List Web Part - Unable to connect to CRM data.

Same thing with my own account.

Clearly there is a permission issue here. Have NTLM authentication only, when I enable Kerobos, I keep getting log in prompts. In my current set up CLEARLY it's working for a log in account, how can I fix it for all others but without elevating permissions?

Advice will be very greatful!!

Answer 2

Hello Uzma,

Did you ever solved your problem? I'm experiencing the exact same problem, and checked permissions everywhere (SQL database, BDC, application...) and they seem ok to me.

Thank you in advance.

Cheers,
Alexandra Ribeiro

---

Alexandra Ribeiro

Answer 3

Found the answer to I think a similar issue when loading CRM 4. It was that the onload Jscript had an error and was causing the Jscript not to load at all. 

At first it seemed like a security or permissions error but the crm user setup (Crm Main Screen -> Tools -> Options -> Privacy (Tab)) was set to: never send an error report to MS about MS Dyn CRM. this was suppressing the error for some users but not others depending on the setting.

To debug with Visuial Studio: add 'debugger;' in the Jscript and set IE to not disable script debugging ( IE -> Tools -> Internet Options -> Advanced (Tab): Disable script debugging not checked) then open the webpage in question. If you do not get a prompt to debug then your script is not even loading and you will have to copy paste into a VS Jscript window to spot check and possibly have to remove or comment out sections to find out where the error is.

I got lucky and spotted the error was that one of the VAR strings had a CRLF in the middle. It would not have been easy to find in the CRM Edit window.

Good Luck,
-Benj

Answer 4

Hi, did you manage to solve it? I am facing the same problem. Thanks

Alvin

Answer 5

Hi,

For BDC always enable Single Sign On and another thing is specify "revert to self" in metadata file (.xml) so that the data becomes flowing between CRM and SharePoint.

I think this should resolve your problem.

---

Manish Patil http://patilmanishrao.wordpress.com Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 6

One of these two approaches should help you resolving the security issue:

1. Ensure that you are using Kerberos authentication (configuration in SharePoint central admin as well as in the domain controller. This is a great post that I always use as referene - http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

Kerberos will ensure that BDC queries CRM as the user you're logged in, hence hat you get from CRM is per CRM security, which makes sense.

2. Configure BDC Application Definition file to connect to CRM as an account which is the Identity account of SharePoint Application Pool. Use "RevertToSelf" instead of "PassThrough"

As for the JavaScript Error, change the type descriptors in the methods to remove new line character / spaces. Yes, lots of change in CRM Applicatio Defination file. For example-

Change following:

<LocalizedDisplayName LCID="1033">

Contact ID

  </LocalizedDisplayName>

 

To:

 

  <LocalizedDisplayName LCID="1033">Contact ID</LocalizedDisplayName>