issues installing v10.0

Business edition tips, tricks, problems and discussions

Moderators: Max, TerryRogers

Post Reply
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

issues installing v10.0

Post by gertone »

Installing the latest EssPIM I was told that I needed a PRO license to access the server (which I do have BTW)

Now it seems something messed up the DB

Code: Select all

------------------------------------------------------------------------------
Exception log with detailed tech info. Generated on 15/12/2021 15:28.
You may send it to the application vendor, helping him to understand what had happened.
 Application title: EssentialPIM Pro
 Application file: C:\00_software\80_administrative\EssentialPIM Pro\EssentialPIM.exe
 Application: EssentialPIM Pro 10.0  14/12/2021
------------------------------------------------------------------------------
Exception class: EIBInterBaseError
Exception message: unsuccessful metadata update
STORE RDB$FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_2"
Problematic key value is ("RDB$FIELD_NAME" = 'DIDITEMINT').
Exception address: 00778B28
------------------------------------------------------------------------------
Main thread ID = 12952
Exception thread ID = 12952
------------------------------------------------------------------------------
Object Logs:
15:28:29.738  DBOpen
15:24:52.498  DBOpen
------------------------------------------------------------------------------
Active Controls:
15:28:30.168  MainForm
15:28:29.319  ConnectDialog OKBtn
15:28:26.961  ConnectDialog GroupBox1 LoginCB
15:28:25.800  ConnectDialog FileCB
15:28:21.742  ConnectDialog ServerCB
15:25:01.423  MainForm
15:24:59.416  ExceptionDialog DetailsBtn
15:24:54.342  ExceptionDialog OkBtn
15:24:53.476  MainForm
15:24:51.304  StatusForm
------------------------------------------------------------------------------
System: Windows 8 Workstation, Version: 6.2, Build: 23F0, ""
Memory: 16263; free 10765
Display: 1920x1080 pixels, 32 bpp, 96 PPI
------------------------------------------------------------------------------
PrevExceptions:
15:25:01.178  unsuccessful metadata update
STORE RDB$FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_2"
Problematic key value is ("RDB$FIELD_NAME" = 'DIDITEMINT')
------------------------------------------------------------------------------
Updates: 1
Last update: 15/12/2021
I hope you can help
admin
Site Admin
Posts: 12462
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1115 times
Been thanked: 774 times

Re: issues installing v10.0

Post by admin »

Please make a copy of your DB, delete all the data from it and forward to us. We'll be able to quickly fix the issue then. Thanks!
Android version of EssentialPIM. Keep all your data in sync!
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: issues installing v10.0

Post by gertone »

Hi Max, thanks for your reply
could you please expand on how to
copy the DB and remove all data from it?

note this is a server license, so I have a windows server with a DB server and an epim db file, but I access this (connect) from a windows client
- my personal login tells me to connect to SYSDBA on the server
- the issue happens when I try to do exactly that
admin
Site Admin
Posts: 12462
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1115 times
Been thanked: 774 times

Re: issues installing v10.0

Post by admin »

Can you physically get access to the database file? If so, please create a copy of it (right click - copy), then paste it into another folder on your local PC. Open the database file locally with EPIM 9.x, then going from one module to another - select all -> delete, after that make sure to optimize the DB in File->Database Management and when this is done, forward it to me via PM here in the forum (or share the download link). Thanks!
Android version of EssentialPIM. Keep all your data in sync!
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: issues installing v10.0

Post by gertone »

I assume I need v9 for that... essentialy meaning I have to reinstall. It does not work with v10
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: issues installing v10.0

Post by gertone »

Before I go installing and older Essential PIM.
Is there an other option
eg.
access Firebird directly through SQuirreL with SYSDBA credentials
run a sql update (the one I assume you would be running on my empty database)
wil make a backup of the database file (I can get to it, no problem)
This seems a whole lot more convenient
admin
Site Admin
Posts: 12462
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1115 times
Been thanked: 774 times

Re: issues installing v10.0

Post by admin »

Another option would be to wait a bit till we release a fix. I think it's going to happen today.
Android version of EssentialPIM. Keep all your data in sync!
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: issues installing v10.0

Post by gertone »

That my friend would be the option I prefer most ;-)
Thanks a lot for that
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: issues installing v10.0

Post by gertone »

Fixed with the new release, thank you
Post Reply