Hi,
Im trying to load the data from MS sql to the oracle through OWB 11GR2 and hence for that i imported the source table from sql server and created target table in the oracle database and after that created Template mapping b/w sql server object and oracle object and generated executed units and deployed it successfully. When i tried to load by giving start, im getting the below error like
Job 59 error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '-'.
while executing
"java0xb execute java0x4 {select
DATA.credit_id AS CREDIT_ID,
DATA.Score2 AS SCORE2,
DATA.obligationRevenue AS OBLIGATIONREVENUE,
DATA.requiredInc..."
(in namespace eval "::SQL\_BPM\_LOCATION\_EU::LCT\_SQL\_TO\_ORACLE" script line 1)
invoked from within
"nseval $srcToTarget execute [java::getinterp] $p_src_stmt $p_src_jndi $p_tgt_stmt $p_conn $p_src_tech $p_tech $p_commitrows"
invoked from within
"set g_res [nseval $srcToTarget execute [java::getinterp] $p_src_stmt $p_src_jndi $p_tgt_stmt $p_conn $p_src_tech $p_tech $p_commitrows]"
while executing
"error $errorInfo"
("if" then script line 11)
invoked from within
"if {[catch {set g_res [nseval $srcToTarget execute [java::getinterp] $p_src_stmt $p_src_jndi $p_tgt_stmt $p_conn $p_src_tech $p_tech $p_commitrows]} r..."
(procedure "source\_to\_target" line 8)
invoked from within
"source_to_target $p_src_stmt $p_tgt_stmt $p_srcvar $connection $p_srctech $p_tgttech $p_tgtcommitrows"
while executing
"error $jdbc_errorInfo"
("if" then script line 2)
invoked from within
"if {[info exists jdbc_errorInfo]} {
error $jdbc\_errorInfo
}"
(procedure "execsourcetarget" line 24)
invoked from within
"execsourcetarget $src_stmt $tgt_stmt "$SRC_LOCATION" "$TGT_LOCATION" "TGT_AC" "" "GENERIC" "ORACLE" -1 "false" "false""
(procedure "5\_LOAD\_DATA\_main" line 33)
invoked from within
"5_LOAD_DATA_main "
while executing
"error $errorInfo"
("if" then script line 4)
invoked from within
"if {[catch {
logTaskStart Started $taskDetail {4} {}
global \_OMBTaskFlowAudit
set \_OMBTaskFlowAudit {TASK\_LOADING|5\_LOAD\_DATA}..."
("if" then script line 2)
invoked from within
"if {$AFTER_ICT == "false"} {
if {\[catch {
logTaskStart Started $taskDetail {4} {}
global \_OMBTaskFlowAudit
set \_OMBTaskF..."
(procedure "5\_LOAD\_DATA" line 27)
invoked from within
"5_LOAD_DATA"
(procedure "LCT\_SQL\_TO\_ORACLE::LCT\_SQL\_TO\_ORACLE\_main" line 51)
invoked from within
"LCT_SQL_TO_ORACLE::LCT_SQL_TO_ORACLE_main "jdbc/SQLSERVER_DATABASE_LOCATION-WKS_OWNER-WKS-PUBLIC_PROJECT-SQL_BPM_LOCATION" "jdbc/ORACLE_DATABASE_LOCAT..."
(in namespace eval "::SQL\_BPM\_LOCATION\_EU" script line 4)
invoked from within
"namespace eval SQL_BPM_LOCATION_EU {
logPhaseStart "" {SQL_BPM_LOCATION_EU} "" {5}
eval [getScript "CODETEMPLATE-WKS_OWNER-WKS-PUBLIC_PROJECT-BUIL..."
null
Thanks in advance. Regards, Dauta