BODS PAR-010102 Error in MS SQL Server Database

[Former Member]

Hi All,

I got a PAR-010102 error while executing a very simple job in BODS 4.1. The job reads a file and dumps the data in a table in MS SQL Server Database. The error message looks like this.

7320	19792	PAR-010102	4/03/2015 6:24:01 PM	|Session Job_STM_PPM_000_0_Extract
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	Syntax error at line <11>: <AlGUIComment ("UI_DATA_XML" =
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	'<UIDATA><MAINICON><LOCATION><X>0</X><Y>0</Y></LOCATION><SIZE><CX>347</CX><CY>-179</CY></SIZE></MAINICON><DESCRIPTION><LOCATION>
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	<X>0</X><Y>-190</Y></LOCATION><SIZE><CX>200</CX><CY>200</CY></SIZE><VISIBLE>0</VISIBLE></DESCRIPTION></UIDATA>',
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	"ui_display_name" = 'ReconcileEPM_SCR', "ui_script_text" = '$L_Errors = \'\';>: near <<> found <<> expecting <')', ','>.
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	Syntax error at line <43>: <END>: near <END> found <END>>.
7320	19792	PAR-010102	4/03/2015 6:24:01 PM	2 error(s), 0 warning(s).

I found SAP Note 1591143 for a similar issue but it is for MySQL DB. Doesn't seem to work in SQL Server.

Can you please help me out resolving the same?

Screenshot Attached.

[Former Member]

I received similar error and was able to fix the issue as below.

One of the Substitution Parameter value was given in the below format

\\abc\def\

I corrected it as below and was able to rerun the Job successfully.

\\\\abc\\def\\