ADTB307: Error executing the SQL statement Alter Table PIPING Alter Column INTEGER


Applies ToAutoPLANT Modeler
Product(s):AutoPLANT Modeler
Version(s):08.11.XX.XXX
Environment:Windows 7/8.1/10 (64 bit)
Area:Error/Logs
Subarea: 
Original Author:Abhijeet Shinde, Bentley Product Advantage Group

Overview

In AutoPLANT Modeler while placing pipe user may following error

Problem Description

When using SQL/Oracle data base with AutoPLANT Project and select distributed Project mode instead of Central Mode user may face this issue.

For ORACLE & SQL Databases Project Mode should be Central Mode and for Access Database you can select Distributed Mode.

This Wiki Article explains the steps to resolve this issue

Steps to Resolve

1. Open the Project Administrator and select the Project

2.Go to Edit and select Preferences

3.Go to Tools and select  Project Conversion Wizard

4.Convert the Distributed Mode to Central Mode

5.Project State will convert

See Also

communities.bentley.com/.../errors-logs-messages-crashes-autoplant-modeler

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround. 

Comments or Corrections?

Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this Comments or Corrections?" section. THANK YOU!