I am using data migrator to extract data from an Adaptive Server anywhere data source with ODBC connection.Suddenly one of the extract is failing with following error:
stg_ihwg_artikel type MS SQL Server Existing target
Request will process data via NON-Pass Through (NON-APT)
HOLD file will be created for output file named: SQLIN.
0 NUMBER OF RECORDS IN TABLE= 28855 LINES= 28855
Bulk Insert active. INSERTSIZE = 1000
0 WARNING.. ON MATCH INCLUDE INPUTS DUPLICATE SEGMENTS
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: HY000
: Microsoft SQL Native Client: [HY000] Invalid input parameter values. Che
: ck the status values for detail.  The parameterized query '(@P1 n
: varchar(20),@P2 nvarchar(80),@P3 nvarchar(4),@P4 numeric(1' expects the
: parameter '@P2', which was not supplied.
(FOC1740) EXECUTE ERROR : STG_IHWG_ARTIKEL
Return Code = 1740
Request: stg_ihwg_artikel - finished processing
CPU Time : 1015
can anybody help me with this error?
Windows, All Outputs
The error message is coming from MS SQL Server and it's saying that you are calling a stored procedure and not supplying a required input value.
Are you calling a procedure through Direct Pass Through (SQL SQLMSS ex sp...)? Or have you created a synonym for the stored procedure and are calling it via a WHERE condition or a JOIN?
Or is the stored procedure being called in some other way, perhaps by a trigger on the target database table?
Thanks for the reply.
The source database is Adaptive server anywhere 9.0 and the target database is MS SQL.
I have created a synonym of the source table "artikel". It loads around 7999 records then stops giving the error SQL code -1 , FOC 1740.
NO stored procedure is used or WHERE condition is also not used.
The target properties are set as:
Prior to load options: Truncate table
Load Type : Insert records from memory
Commit every row (s) : 1000
No. of records records laoding in block : 1000
Is there a way I can find if there are any duplicates? or is there a way to identify the duplicate records and then reject them?
Windows, All Outputs
|Powered by Social Strata|