Troubleshooting - Intergraph Smart Reference Data - 2020 10.0 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

Error: Bulkload API call threw System.Exception: MAR 44041| … ~…~Oracle~Could not load file or assembly 'CommonMiddle, Version=1.0.0.0…

t1

Solution: Check to see if the SPRD Listener is started from the correct installation path.

Error: Bulkload API call threw System.Exception: MAR-44041| ...~…~ Oracle~Active site connection is already established, you cannot switch to another site.

t2

Solution: Check if the current Smart 3D Active Site on the machine is where the SPRDListener is running is as per the Destination details mentioned in the export job.

Error: SPRDListener.exe – System Error: … ServerContextSupport.DLL is missing…

t3

Solution: Enter the path value "/core/runtime" for the Smart 3D installation in the Path environment variable. For example: "c:\Program Files (x86)\smartplant\3d\core\runtime;"

t4

Error: Bulkload API call threw System.Exception: MAR-44040| ...INGRNET.COM~No connection could be made because the target machine actively refused it

t6

Solution: Check whether the Export Destination settings are correct. The server name should be the one where the SPRDListener is running. Also, check to see if the SPRDListener is running.

Error: Bulkload API call threw System.Exception: ORA-12154: TNS: Could not resolve the connect identifier specified…

t6

Solution: The TNS entry in the application server settings may be missing. Check to see if the required TNS entry exists in the Oracle Client home on the Smart Reference Data application server.

Error: Bulkload API call threw System.Exception: MAR-44040| ...~A connection attempt failed because the connected party did not respond properly after a period of time…

t7

Solution: Check to see if the SPRD Listener is running.

Error: Bulkload API call threw System.Exception: MAR-44042|...~This catalog is not associated to the active site.

t8

Solution: Check to see if the destination data used in the export job is entered correctly on Integration > Smart 3D > Smart 3D Transfer Jobs > Destinations.

Pay close attention to the case-sensitivity of the catalog database and site database entries.

Error: Bulkload API call threw System.Exception: Could not find file ‘C:\Temp\...log"

t9

Solution: Check to see if Notepad has the Word Wrap option cleared. The path for the symbol files should not have any blank spaces.

Error: Unknown switch files

Solution: The path for the symbol share path for the active catalog database on the Smart 3D computer should not have any blank spaces.

Error: ORA-01017: invalid username/password; logon denied

Solution: Verify that the user name given for SP3D_LOGON_USER has the SP3D_PROJECT_ADMINISTRATOR role assigned on the Smart 3D database server.

Error: Unhandled exception occurred using the test utility.

Smart Reference Data log file:

...

0.229 s : Connecting to S3D machine <IN-SP3DCERT16A>

0.343 s : Connected.

0 s : Connecting to Site DB <SPRDTESTsite> at Site Server <IN-SP3DCERT16A> provided by MSSQL

0.371 s : Error: Bulkload API call threw System.Exception: MAR-44041|SPRDTESTsite~IN-SP3DCERT16A~MSSQL~Because of security restrictions, the type SPRDHelper.DBServerProviderTypes cannot be accessed. ---> System.Runtime.Serialization.SerializationException: Because of security restrictions, the type SPRDHelper.DBServerProviderTypes cannot be accessed. ---> System.Security.SecurityException: Request failed.

This problem occurs when Smart 3D 2011 R1 is installed without patches and then you use the load API.

Solution: Install the needed patches and retry.

Error: Bulkload API call threw Intergraph.Sprd.S3DUtility.ConnectionRefusedException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Smart Reference Data log file:

Bulkload API data log

This problem occurs when an active firewall interrupts the load API process.

Solution: Check to ensure that firewall is not interrupting the load API process.