invalid identifier error

sdfasih · Post by **sdfasih** » Fri Aug 18, 2006 5:50 pm

Hi ,
I am getting this error while loading fact table
FACT_LOAD_FINAL_vrp_posn..Dynamic_RDBMS_47: ORA-00904: "TNT_ASSET_ACCT_SID": invalid identifier

TNT_ASSET_ACCT_SID is a column
i donno the reason please suggest
thanx

meena · Post by **meena** » Fri Aug 18, 2006 5:59 pm

Hi,
Check with the metadata or column existing in the table. And you can do a search on this in the forum..

chulett · Post by **chulett** » Fri Aug 18, 2006 8:13 pm

TNT_ASSET_ACCT_SID may in fact be a column in the table you meant to access, but it's not in the table you are actually referencing in the job. Hence the ORA-00904 error. Check your job carefully... perhaps it is mispelled or the wrong tablename is being passed. Or the right tablename in the wrong schema. Or...

DSguru2B · Post by **DSguru2B** » Fri Aug 18, 2006 10:42 pm

Re-import the table definition for that particular table. This happened to me a couple of times as my dba changed his db script for the x.next version of the database on friday and sent out the mail on monday.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 18, 2006 11:03 pm

Your DBA owes you at least an apology!

chulett · Post by **chulett** » Sat Aug 19, 2006 7:12 am

Perhaps... if something actually changed. However, it's simple enough for someone to copy a job, replace all the metadata with a new table's columns but forget to actually change the name of the table in the stage. First time you run it... Invalid Identifier.