Friday, March 12, 2010

ORA-01036: illegal variable name/number

Error:- ORA-01036: illegal variable name/number
Env:- Crawling Oracle database and views from SP BDC using SSO.

I had used BDC Meta Man to create the ADF file and after that it was giving the below error while doing full crawl. After working with the BDC support, I found out that the Identifiers we specify in the tool are suppose to be unique in data. Once selecting those Unique identifiers, import the ADF file again and crawl from SharePoint, it will work fine.

Log Name: Application
Source: Office SharePoint Server
Date: 3/12/2010 10:08:30 AM
Event ID: 5701
Task Category: Business Data
Level: Error
Keywords: Classic
User: N/A
Computer: server name
Description:
Could not run query/stored proceedure 'Select ORACLE STRING QUERY Pooling=True;User ID=readonly;Integrated Security=False;Persist Security Info=false;User ID=readonly;' in App Domain 'DefaultDomain'. The full exception text is: ORA-01036: illegal variable name/number

Event Xml:
event xmlns="a href="http://schemas.microsoft.com/win/2004/08/events/event/a>">
5701
2
1330 0x80000000000000 10916226
Application Servername

Select ORACLE STRING QUERY Pooling=True;User ID=readonly;Integrated Security=False;Persist Security Info=false;User ID=readonly;
DefaultDomain
ORA-01036: illegal variable name/number

Total Pageviews