# FAQ and Troubleshooting
See below for common troubleshooting steps. If any issues or questions arise, please contact support@petro.ai.
# PetroSuite
# Some PetroSuite Tables are Missing/Have No Data
Some tables within PetroSuite (e.g. Jobs Manager table) are updated with real-time data from the PetroDatabase using a MongoDB feature called change streams. If these PetroSuite tables are missing or have no data, it isindicative of an issue with the PetroDatabase.
Ensure that the database user provided for PetroManager has the changestream and find permissions and that the MongoDB cluster is operational. In some rare cases the MongoDB cluster may need to be rebooted.
# Blank Job Manager Page
Replica Set may be configured incorrectly.
# Mismatched version on bottom of application and in Settings > Info
Turn on Dev Tools in the Chrome browser and hard reset the browser and cache.
# PetroCore
# Error 193, 0xc1 - Petro.ai is not a valid Win32 application
If an Error 193 is thrown by Windows while trying to start PetroManager or PetroWorker services, ensure that the machine program files directory and environment variable has not been corrupted. Occasionally an additional corrupted file called Program will be created on the root drive that is incorrectly treated as the machine’s program files directory. Simply removing this corrupt file and ensuring that the program files environment variable resolves will correct this issue.
# PetroManager or PetroWorker Service Will Not Start
Run the executable in the cmd window to see output logs.
If the issue continues, ensure that RAI.PetroCore.exe has not been blocked by Windows security as an external executable. This can be verified by right clicking on RAI.PetroCore.exe file and viewing properties. In the security section (see below), simply check the Unblock box.
# Integrations – Spotfire
# Hard time getting to the data
You may want to check security roles for the user connecting to MongoDB,this can cause some users not to return information to the Spotfire interface.
# Can’t connect to the database
Possibly an incorrectly formatted connection string. In Spotfire, the connection needs to look like this: (notice the database name, auth source, and replica set name placement)
mongodb://[username:password\@]host1[:port1][,...hostN[:portN]]][/[**database**][?options]**&replicaSet=\<name\>&AuthSource=admin**]
# Connection string not showing up in PetroPanel
You can check the user’s Spotfire groups in Admin Manager. This is typically caused by a user belonging to two conflicting groups or because of the way Administrator and Everyone do not share preferences.
# Connection string issue with Windows Domain-style table names
You'll need to escape it twice. Once for the job manager and again for the submitted SQL query.
Therefore PETRO\lwood becomes PETRO\lwood and then again to make PETRO\\lwood.