Folder Validation Error -

SUGGESTED

Dear Team,

We have a situation where after coping the V11 folder from the production server and validate it in V12  in the Test server the V12 system shows the below-mentioned errors.

Process Start on TEST SINVOICE USINVOICE U01
Table Validation USINVOICE
COPY DATA FROM SINVOICE TO USINVOICE ...
<0001 @X3.TRT/TRTMIG$adx (999)
<0001 Error 76 : SQL Server Error
<0001 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'CRN_0'.
<0001 INSERT INTO TEST.
<0001 USINVOICE(
<0001 ACCDAT_0

Does anyone have any thoughts around what is causing it, and how to resolve it?

Parents Reply Children
  • 0 in reply to AndrewV

    After doing folder import and while doing Folder Validation, I got this error message i.e. COPY DATA FROM SINVOICE TO USINVOICE ...
    <0001 @X3.TRT/TRTMIG$adx (999)
    <0001 Error 76 : SQL Server Error
    <0001 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'CRN_0'.

    After I got the above-mentioned error I have noticed that SINVOICE Table was empty and in USINVOICE table there were 9000 rows.

    I have removed the Folder and again did folder import with a different name. 

    After doing folder import, I have noticed that USINVOICE table was missing and there were 9000 rows in SINVOICE table.