Skip to main content

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

 

@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


@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.


@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


@Rukmal Fernando 

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


What is your installation’s UPD level?


 IFS10 UP10 . TAS version in the installation file is 10.9


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


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


@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.


thanks for help


Reply