This content has been marked as final. Show 5 replies
What version of Apps is this? What version of OS is INFA running on? Could you pl check the content of the parameter file.
in DAC > Run History > Task Details, query
Name = SDE_ORA_Product_Category_Temporary
Open Status Description, look for string -lpf, the file after it is the actual parameter file DAC send to INFA server. E.g
Open the parameter file, most likely the [session_name] does not match with SDE_ORA_Product_Category_Derive_Full or some parameters are missing.
Thanks for your replies. I'm out of the problem now. The problem got resolved after restarting the system and running the ETL process. I'm very much surprised what caused the problem. I didn't do anything other than restarting the system.
I have got the same problem and I couldnt find anything to solve it.My error code is ;
RR_4035 SQL Error [ ORA-00936: missing expression ]
I restart the computer but nothing changed.Is there anybody knows what do I have to do to handle this error.
Version : 7.9.5
Somewhere you are missing the comma or some other expression with in the SQL, try running the sql in toad and then run the ETL.
Edited by: 900739 on Dec 5, 2011 10:10 AM
Edited by: Mahesh on Dec 5, 2011 10:11 AM