Search This Blog

Wednesday, July 22, 2020

A syntax error occurred at line 444 in file XX.ldt An entity data line was expected No data found for upload


Issue -
We are not able to migrate the concurrent programs from one to another environment using FNDLOAD UPLOAD. i.e. from DEV to PROD

Error details –
Uploading from the data file XX.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dump from LCT/LDT files (/u01/app/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2), XXB.ldt) to stage tables
Dump LCT file /u01/app/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2) into FND_SEED_STAGE_CONFIG
Dump LDT file XX.ldt into FND_SEED_STAGE_ENTITY
A syntax error occurred at line 444 in file XX.ldt
An entity data line was expected
No data found for upload

Assumption -
The file versions are different, due to some other RUP patches in DEV


PROD -
Dump LCT file /u01/app/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.2)

DEV -
Dump LCT file /u01/app/applmgr/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpprog.lct(120.2.12010000.15)

Workaround -  Change the following in LDT file

  1. LDRCONFIG = "afcpprog.lct 120.2.12010000.13" to LDRCONFIG = "afcpprog.lct 120.2.12010000.2"
  2. Find the word RECALC_PARAMETERS and Remove that line

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...