This has now been resolved, the problem was a component part under one of the PO parts.
Hi Dumeesha,Thanks for your reply.I will look at the layout option.RegardsSteve
Hi, the only way i could get it to import was through the Aurena client.We as a business never use the Aurena Client so this was quite unusual, but the answer to your question is you have to use the Aurena client.
Hi,Before i raised a case i managed to open and read one of the logs and the issue was stuck application messages, there were 2 messages stuck in a state of “Processing”I shutdown and restarted the middleware and the messages have been processed correctly, the log file is now back to normal!Thanks for your help!Steve
ok i will raise a case thanks
Hi Banu,Thanks for the information, our logging is the same as in your image which i believe is the default.I cannot understand why the files are huge at 17gb in size everyday and I cannot read any as they are so big!ThanksSteve
I have finally got to the bottom of this, in tnsnames.ora the PDB entry was missing hence why the 12154 error code.As soon as this was updated the Reports ran fine.This happened when updating Oracle.Thanks for all you help!
I have followed your advice and installed the webservice again but its still the same?1/25/2020 9:39:57 AM[IFSCRWebSetup]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.11/25/2020 9:39:57 AM[IFSCRWebSetup]-Failed to open the connection.Details: [Database Vendor Code: 12154 ] Failed to open the connection.Details: [Database Vendor Code: 12154 ] Failed to open the connection.ArrivalReportAxis1 12868_3284_{32833AAA-F9D9-4FB5-AD8C-A95759485318}.rptDetails: [Database Vendor Code: 12154 ] at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable) at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value) at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFSCRWebSetup\App_Code\Service.cs:line 1409 at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCR
Just thinking about this again, we have also changed the IFSSYS password, I see this is stored in the ifs-crystal-config.xml encrypted?Do you need to update this?And if so how?
Hi Kasun,Thanks for the replyI have checked and can verify that the crystal web service can access the database (these are hosted on the same machine).Also I can verify IFSSYS has permission to ARRIVAL_REPORT_REP_ Steve
Hi thanks for the help, this was indeed the fix for this problem!Importing the logo through the Aurena Client
Thanks Yasas i will take a look
Hi Yasas,Thanks for the reply, i will go and take a look to see if i can find a solution.ThanksSteve
Thanks for your help on this, we cannot find anything that looks out of the ordinary. We will proceed to raise a case with IFS Thanks
Firstly thanks for the reply! After what you said I looked at the error message again, the AXIS1 is the site, it looks like the Part No portion is blank\null? I have looked at parts created on or after the 14th May and cannot find anything obvious The error message shown is all that's available in the MRP background job.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
