Focal Point
FOC1740 error execution error.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5967034026

May 22, 2012, 04:36 AM
Ram Shirali
FOC1740 error execution error.
Hi,

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
Issuing PREPARE
Request will process data via NON-Pass Through (NON-APT)
HOLD file will be created for output file named: SQLIN.
1
0 NUMBER OF RECORDS IN TABLE= 28855 LINES= 28855
0
Bulk Insert active. INSERTSIZE = 1000
Starting Load
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. [42000] 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
Ending Load
Return Code = 1740
Request: stg_ihwg_artikel - finished processing
CPU Time : 1015
Output retrieved


can anybody help me with this error?

Regards,

Ram


WebFOCUS 7.6
Windows, All Outputs
May 23, 2012, 04:51 PM
Clif
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?


N/A
June 28, 2012, 05:02 AM
Ram Shirali
Hi Clif,

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?

Thanks,

Ram


WebFOCUS 7.6
Windows, All Outputs