SPIBACKUP AND UPGRADE文档格式.docx

SPIBACKUP AND UPGRADE文档格式.docx

《SPIBACKUP AND UPGRADE文档格式.docx》由会员分享，可在线阅读，更多相关《SPIBACKUP AND UPGRADE文档格式.docx（10页珍藏版）》请在冰豆网上搜索。

10/30/2016

RelevantProduct（s）

SP_INSTRUMENTATION

Issue

WhenattemptingtocreateaWatcom 

backup 

thefollowingerrormessageoccurs:

Failedtoconnecttoadmininthesourcedatabase.999:

SQLSTATE=IM002

[Microsoft][ODBCDriverManager]Datasourcenamenotfoundandnodefaultdriverspecified

ContactIntergraphSupportforfurtherassistance.

Sameworkstationcan 

somedatabases,butnotothers.

Environment

ReportedinVersion:

SP_INSTRUMENTATIONv2013HF7（10.00.00.0256）

Notversionspecific

Resolution

Notedthatthismachinewasableto 

aUSdatabase,butnotfromaChinabasedDB.Whileshowingthatoneworked,andonedidnot,sawthattheversionofMSSQLswitchedfrom2012to2008inthe 

dialogbox.（2k8fortheonethatfails）.

Siteswitchesinifilesbyuseofautility.CheckedtheiniandfoundthatfortheChinadatabases,theDBParmlinespecifiedMSS2008,butforUS,ithadMSS2012.

ManuallyeditedtheChina.inifiletoMSS2012andthe 

started（gotpasttheODBCerror）.

Finalresolutionwastofixthesource.inifilecopiedbytheutility.

Cause

Incorrect.inifilesetting

Badintools.inifilecauses"

InconsistencybetweenDatabaseandApplication"

messagewiththesameversionnumbers

21562 

6/25/2014 

2/4/2016

UnabletorunSPIduetothefollowingmessage:

InconsistencybetweenDatabaseandApplication

Applicationversion:

09.00.02.0176

Databaseversion:

Reportedinversion:

SP_Instrumentationv2009SP2（09.00.02.0176）

Notversionspecific.

Thismessagecanbecausedbyanintools.inifilethatdoesnothaveproperconnectionparameters.

Replacethecorruptintools.inifileusingoneofthefollowingoptions:

1.Copytheintools.inifromadifferentcomputerthathaspreviouslyconnectedtothesamedomain.

2.CheckDatabasesectionofintools.inifileandensurealltheconnectionparametersareappropriate.Manually 

makeanyneededcorrections.

3.IfthisistheoriginalSPIclientwheretheintools.iniwascreated,renamethecurrentintools.ini,copyintools.pbz,andrenamethecopytointools.ini.

Ifthisdoesnotresolvetheissue,seeifacorruptc_ver.pbdfileisthecauseasdescribedin 

Answer22423.

Theintools.inifiledoesnothaveproperconnectionparameterstoconnecttothecorrectdatabase.

AnSPI 

processwasinterruptedanddidnotfinishsuccessfully.Whentheprocessabortsoriskilled, 

thedatabaseconnectionparametersinintools.inifilearenotresetasrequired.

InconsistencyBetweenDatabaseandApplication

31119 

12/28/2017 

12/28/2017

Iwasdoinga 

ofmydomainandduringthisprocessAdministrationcrashed.

However,whenItriedtoopenAdministration\SPIagain,igot:

SmartPlantInstrumentation

=======================

6799424

6799426

-------------------------------------------

OK

Ilookedtheintools.iniandIcouldnotfindanythingthatcouldberelatedwiththisissue.

IcheckedtheProjectandLicensetablesandbothshow6799424.

C_ver.pbdalsoshows:

SP_INSTRUMENTATIONv2016SP1（11.00.01.0296）.

Wefoundunder:

C:

\Users\<

USER_NAME>

\AppData\Local\VirtualStore\ProgramFiles（x86）\SmartPlant\Instrumentation

Acopyofintools.iniandc_ver.pbd

Oncewedeletedthemboth,allworkedasitshould.

Informational.

FailswithNoDefaultDriverError

27900 

10/25/2016 

10/26/2016

AttemptsatrunningSPISybaseSQLAnywhere（Watcom） 

backups 

oncertainMS-SQLdomainsfail,whileothersrun,fromthesamephysicalmachine.

Itfailsalmostimmediatelywiththefollowingerror:

Tested 

ofsuccessfuldomainandthenswitchedusingacustombatchutilitythatchanged.inifilesandtestedabaddomain.

Notedthatthedatabasesectionofthe 

formstatedthedomainwasMSSQL2012forthegooddomain,andMSSQL2008forthebad.

Onlyoneclientinstalledonmachine.

Reviewofthetwo.inifilesshowedthattheDSNvalueforthebaddomain.inifileswasMSS2008.

Switchedthevaluet