When I am upgrading AM 5.22 to AM 9.4,I am getting the error in following step
6. Select Action/ Templates/ ORACLE batch for BLOB migration from the menu bar. This generates an Oracle SQL+ batch file named migratelob.sql by default, which contains instructions to convert LONG and LONGRAW fields to CLOB and BLOB respectively. 7. Use a database utility such as ORACLE SQL+ Prompt to run the migratelob.sql batch file. Example: SQL> @C:\Users\encornet\AppData\Local\Temp\migratelob.sql This converts fields to the new data types, after which the standard database upgrade can proceed."
After run this SQL command,I am getting the attached error
Thanks Priya.I am getting one more error during upgradation. Step:Importing the Standard Reports Provided with Asset Manager 9.40 (1)Select the Open database description file - create new database option. 2. Select the standard 9.40 gbbase.xml file, located in the config sub-folder of the Asset Manager 9.40 installation folder. 3. Select the Action/ Create database menu. 4. Populate the pages of the wizard as follows (navigate through the wizard pages using the Next and Previous buttons): Generate SQL script / Create database page:)
Error:"This script does not have the necessary write-access rights.('Line 3 of script 'pgCrBase.bEmptyDb.Value,line 140")