Unable to find inspection record which a Street Authority says they have sent.
If you’re unable to find an inspection record which a SA says they have sent you then you should first check that you have access to view the works details in the TMA1000 form to ensure that the street group security isn’t stopping you viewing any of the details. If you can see the works record successfully then you need to check that the batch file which the inspection was sent in was actually received and also check that the batch file was loaded successfully.
You should ask the SA for the batch file name they sent the inspection in and also when they sent it. Then open your FTP logs, browse to the date you think you should have received it and check to see what is stated about that batch file. If you can’t see any details for the batch file then check a few of the following days to see if it was sent to you late. If you still can’t see any details then this would mean that it wasn’t received on your server so check with the SA to see what FTP details they have for you and also ask them to check their FTP logs.
If you can see the batch file in the FTP logs then you should check the loading status of the file in the application. In the application open the TMA Manager->Data Exchange->Batch Processing->Inspections->Inspection Batch File Summary form TMA5510. Run a query for the batch file name ensuring that you include a wildcard (%) or .txt on the end. If the Read/Write Error box is ticked then details of the file loading error should be shown at the bottom. If the TRX Error(s) box is ticked then click Links->Transactions which will open the Inspection Upload Transaction Summary form and query the transaction errors for records in that batch file – this will then show you why each of the inspections in the batch file failed to load.
If you can’t find any details of a loading attempt in the TMA5510 form then it is possible that there has been a problem moving the file from your FTP server to the location where the database uploads them from on the DB server. This move is normally done by a bespoke method setup by the user, however it is sometimes done using Exor Mobile Connect so check this is running as it should.
Another problem that could stop the live database uploading the files is if a clone of the live system has been replicated on the same database server. If a clone exists then check if the database job for uploading inspections has also been copied across – if it has then drop it and re-queue any files which may have been loaded by the clone by cutting them from the Pass/Fail directories to the TMA_INSP_IMPORT_DIRECTORY directory.Problem Reference: 60791
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!