Skip to main content
Question

ORA-02270: error during installation of IFS TouchApps Server

I get ORA-02270: error during IFS TouchApps Server installation and I cannot overcome it.
Can you help?

 

10 replies

Rukmal Fernando
Rank
Userlevel 5
Badge +14

@betul.bastan_12 does your TASTrace.log file have anything more? Also, what was your UPD level prior to doing this upgrade?

Best regards,

Rukmal

B
Rank
Badge +2

@betul.bastan_12 does your TASTrace.log file have anything more? Also, what was your UPD level prior to doing this upgrade?

Best regards,

Rukmal

Günlük kaydında hata "

    DateTime=2024-07-23T13:53:05.8290731Z
IFSTouchAppsServerInstaller.exe Bilgileri: 0 : Veritabanı Yükleniyor / Güncelleniyor
    DateTime=2024-07-23T13:53:05.8290731Z
IFSTouchAppsServerInstaller.exe Bilgileri: 0 : --------------------------------------------------------
    DateTime=2024-07-23T13:53:05.8290731Z
IFSTouchAppsServerInstaller.exe Bilgileri: 0 : Veritabanı yükseltiliyor.
    DateTime=2024-07-23T13:53:05.8446918Z IFSTouchAppsServerInstaller.exe Hatası: 0 : 141019-ZAPZAP-2944.2 DECLARE c NUMBER(10,0);  BEGIN SELECT COUNT(*) INTO c   FROM USER_CONSTRAINTS   WHERE TABLE_NAME='CLOUD_APP_VERSION_DOWNLOAD_LOG' AND CONSTRAINT_NAME='FK_SYSTEM_DOWNLOAD_LOG'
yürütülemedi  ; EĞER c = 0 İSE HEMEN ÇALIŞTIR  '"CLOUD_APP_VERSION_DOWNLOAD_LOG" TABLOSUNU DEĞİŞTİR"FK_SYSTEM_DOWNLOAD_LOG" KISITLAMASI EKLE"  FK_SYSTEM_DOWNLOAD_LOG" YABANCI ANAHTAR ("SERVICE_INSTANCE_ID") "SERVICE_INSTANCE_TAB" ("SERVICE_INSTANCE_ID") SİLME AŞAMASINDA'; SON EĞER; SON; <Oracle.ManagedDataAccess.Client.OracleException><Mesaj>ORA-02270: Bu sütun listesi için eşleşen benzersiz veya birincil anahtar yok ORA-06512: 2. satırda</Mesaj></Oracle.ManagedDataAccess.Client.OracleException>     DateTime=2024-07-23T13:53:05.8446918Z IFSTouchAppsServerInstaller.exe Bilgileri: 0 : ORA-02270: Bu sütun listesi için eşleşen benzersiz veya birincil anahtar yok ORA-06512: 2. satırda     DateTime=2024-07-23T13:53:05.8446918Z IFSTouchAppsServerInstaller.exe Bilgileri: 0 : ---------------------------------------------------------     DateTime=2024-07-23T13:53:05.8446918Z IFSTouchAppsServerInstaller.exe Bilgi: 0 : Hatalar nedeniyle kurulum iptal edildi.     DateTime=2024-07-23T13:53:05.8603191Z

 

”

Hatayı incelediğimde sistemde SERVICE_INSTANCE_TAB olmadığını fark ettim. Kurulum adımlarında bu tabloyla ilgili bir şey bulamadım. 
Yükseltme yapmıyoruz, ilk kez kuruyoruz.

Rukmal Fernando
Rank
Userlevel 5
Badge +14

@betul.bastan_12 I tried to translate your message, but I didn’t see anything helpful. Can you doublecheck your steps against this please? https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/030_touch_apps/010_touch_apps_server/010_prepare_db/hidden_itd/025_prepare_tas_db.htm?nobanner=true

Also, are you really on UPD9? That was released almost four years ago, so you’re running a pretty old TAS.

Best regards,

Rukmal

B
Rank
Badge +2

@Rukmal Fernando 

This is the Touchapps installation file in our Build file. Could the error be caused by the version?
Thanks for your help

Rukmal Fernando
Rank
Userlevel 5
Badge +14

What is your installation’s UPD level?

B
Rank
Badge +2

 IFS10 UP10 . TAS version in the installation file is 10.9

Rukmal Fernando
Rank
Userlevel 5
Badge +14

If you’re on UPD10, you should install the 10.10 version of the TAS. You’ll find the installer in the Build Home’s manualdeploy file as documented here: https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/030_touch_apps/010_touch_apps_server/default.htm

B
Rank
Badge +2

Yes, I tried to install by following this document. but the TAS version in Build Home's manual deploy file is 10.9

Rukmal Fernando
Rank
Userlevel 5
Badge +14

@betul.bastan_12 if the rest of your environment is already on UPD10, your Build Home should already have the 10.10 TAS. If that’s not the case, I think your admin would be the best person to help you find the correct Build Home.

B
Rank
Badge +2

thanks for help

Reply


Terms & ConditionsCookie settings