| Author |
Message
|
| mike123 |
 Posted: Fri May 18, 2012 12:05 am Post subject: Failed to locate constant |
 |
|
Newbie
Joined: 17 May 2012
Posts: 4
|
I am facing the error "Failed to locate constant in Production in exception.
Below is the scnerion on the above errror:
1)we are receving the file from FTP and the file was placed in the some "src_eai" Folder
2)File input node receves the file from the "src_eai and moves to the mqsiarchive folder.
3)Next we are inserting the data in the database and transformation
4)we could see the data empty in the database and during the transformation the data its getting failed and we are getting the Error "Failed to locate constant"
Could you please let us know why there is no data in the database.As the file was processing and it moves to the MQSIARCHIVE FOLDER |
|
| Back to top |
|
 |
| Esa |
| Posted: Fri May 18, 2012 12:26 am Post subject: Re: Failed to locate constant |
|
|
Grand Master
Joined: 22 May 2008
Posts: 1387
Location: Finland
|
| mike123 wrote: |
Could you please let us know why there is no data in the database.As the file was processing and it moves to the MQSIARCHIVE FOLDER |
Obviously your exception handling lets the FileInput node commit after the exception.
Run user trace and you will know the cause of the problem. It seems your exception handling does not log the whole exception tree, otherwise you would know the cause.
If and when you need more help, it is a good practice to provide information on you broker and OS version. |
|
| Back to top |
|
|
| mike123 |
| Posted: Fri May 18, 2012 2:24 am Post subject: Failed to locate constat |
|
|
Newbie
Joined: 17 May 2012
Posts: 4
|
Thanks ESA for the kind reply.
I am not seeing this exception for all the files.which we are receving.Its only for few files.
The failed files which has a copy in mqsiarchive folder.when we are replaying the files again placing the file back agian to in src_eai_in folder this time the file is getting processing successfully.But during first time its getting failed.
Here why its getting failed during first time during ftp and why its getting succes during replay by manually placing the file in the src_eai folder
In the exceptioin we are getting full exception with parser exception at Resecent content descritor node where we are doing message validation with message set.
The root cause of the parser exception is since there is no body in the messge its gettting failed with parser exception.
Please suggest on the file processing issue.. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri May 18, 2012 2:34 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
if your file is being ftp'd over I suggest you ftp it into a different directory and do the move to the broker pickup directory as a post ftp step. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mike123 |
| Posted: Fri May 18, 2012 9:26 am Post subject: Failed to locate constant |
|
|
Newbie
Joined: 17 May 2012
Posts: 4
|
Thnaks fjb_saper for the reply..
We tried this option also placing the file in temp folder and moved to the broker acces folder i.e src_eai_in.
In this scenerio also we are facing the error "failed to locate constant" where the file was sucessfully moving to the MQSIARCHIVE folder but having o byte file in the database.
Do we have any other option on the error.Pleae let me know |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri May 18, 2012 10:48 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
maybe you need to treat DB warnings as errors?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mike123 |
| Posted: Sat May 19, 2012 1:18 am Post subject: Failed to locate constant |
|
|
Newbie
Joined: 17 May 2012
Posts: 4
|
The issue with is not only a o byte in the Database.
We are not seeing any message in the queeu also.
Why the file was not processing after the file was copied to mqsiarchive where there is no data in the Body in MESSAGE TREE STRUCTURE which gets failed in the Message flow processing.
Any more suggestion more? |
|
| Back to top |
|
|
|
|
