User login
|
|
Frontpage Sponsor
|
|
Poll
|
What do you expect from your SI Implementation partner for the success of ERP implementation. Bring best practices - Not to offer more CR's Leveraging standard functions 17% Need more honesty to work with the Users until their processes are fully mapped & Users are trained 50% Focus on process automation/ integrations/ Real time data/ BI analytics 17% Stick to basics 17% Total votes: 12 |
Baanboard at LinkedIn
|

|
|
|
 |
|

19th July 2019, 15:49
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Reconfigure Tables has no effect
Baan: ERP LN 6.1 DB: Other/Unknown OS: Linux - Other C/S: None/Unknown
Dear all,
I hope someone can help me with this as I really am stuck now. This is something I have done multiple times with no problems, and now I cannot get it to work any more:
Setup:
I have two companies, 300="b61a9dev" and 100="b61a9tes".
== What works ==
I have added a new field "fbtest" to table tdsls400 in company 300. I convert to runtime, reconfigure tables. In my oracle server, I can query the field e.g. by,
SELECT t$test FROM baan.ttdsls400300;
In the data dictionary, I can see the changes in
/Infor/ERPLN/bse/dict/ddb61a9dev/dtdsls400 (e.g. the line ":NAME:tdsls400.fbtest").
All is well.
== What does not work ==
Now I do the exact same thing on the other company:
I add the new field "fbtest" to table tdsls400 in company 100. I convert to runtime, reconfigure tables. I notice that the usual messages "Reconfiguring tables" and "Repairing referential integrity" do not appear, the process is finished instantly.
The field is not visible in the oracle db:
SELECT t$test FROM baan.ttdsls400100; --fails on unknown column.
The data dict file (/Infor/ERPLN/bse/dict/ddb61a9tes/dtdsls400) is untouched.
I have tried adding fields to other tables in company 100, that works.
I have tried adding fields to other tables in other companies, that works.
I have tried adding the field in tdsls400, company 100 with differing name, domain, label. None of that works.
I have tried the reconfigure tables command focused only on my table, on the whole package, on the whole VRC, with and without reconfigure tables, nothing works.
I have removed and added the field to the table multiple times. Doesn't work.
I have checked the log files. No mention of my table in any of them, specifically not in log.reconfig.
I have checked table ttadv502000 and can see that after adding my field it contains an entry (b61a9tes,2,tdsls400,0,0) which disappears when I reconfigure tables despite nothing happening to either table or dictionary.
I have recreated the complete data dictionary for that company, no result. However, then log.reconfig says "tdsls400100 C0 0 No reconfiguration is needed".
Any hints on what is wrong with my system or where to look further will be greatly appreciated!
Florian
|

22nd July 2019, 05:39
|
 |
Guru
|
|
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,149
|
|
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x -
DB: Oracle,MS-SQL -
OS: HPUX, Linux, Windows
|
Quote:
I have added a new field "fbtest" to table tdsls400 in company 300.
|
Quote:
I add the new field "fbtest" to table tdsls400 in company 100.
|
It is not clear how can/did you add a new field to a company? You have to add a field to the table in the VRC that is linked to the Package Combinations (b61a9dev and b61a9tes) and then execute the run-time sessions (ttadv5210m000, ttadv5215m000) for the Package Combination(s) so the Data Dictionary files to be regenerated and the new fields to be applied to the Database.
Refer to - Companies and Users
Version Management
so you can have some clear understanding of the concept of the Package VRC's, Package Combinations and Companies.
|

22nd July 2019, 07:59
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Dear NPRao,
Thank you for trying to help and sorry if my wording was unclear. I understand about VRC, that is not my problem. I was using the company numbers in the text because of the more obvious link to the database table names (that have the company number as suffix as in tdsls400100 / tdsls400300). I mentioned the VRC for those companies in the intro.
And I know how to regenerate Data Dict or apply field to the database - as you can see from the fact that I did it successfully in the Package Combination b61a9dev, and from my statement that I did it successfully on other tables in b61a9tes.
My problem is that it does not work for _one specific table_ in a _single VRC_.
|

22nd July 2019, 10:12
|
 |
Guru
|
|
Join Date: Feb 2009
Posts: 650
|
|
Baan: Baan IV -
DB: Oracle -
OS: HP-Unix
|
Okay lets go step by step.
After adding the field in tdsls400 Table in Company 100, you did crdd,
What did the log log.ottadv5215 say?
|

22nd July 2019, 13:55
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,806
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
One of the things we ran into was the data dictionary files out on the servers had the wrong permissions.
__________________
Mark
GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
|

22nd July 2019, 14:41
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Dear Ajesh, mark_h,
Thank you both for helping me with this!
I have tried again, doing these steps:
- Opened the table tdsls400 in ttadv4520m100 (Tools/App.Dev/Domains&Tables), - Added new field "fbtest", domain tc.ynna, default tcynna.no, no label.
- Convert to Runtime DD (+Reconfigure Tables, +Runtime Directories) in Session ttadv5215m000 over the whole of b61a9tes, all packages, all tables. Process prints no errors and finishes in <1 second, no messages shown.
The log directory does NOT contain a logfile log.ottadv5215!
I was also suspecting the permissions, but couldn't find anything wrong. Here's the two relevant files for tdsls400 in the two VRCs:
-rw-rw---- 1 bsp app_ERP 11649 19. Jul 15:20 ddb61a9dev/dtdsls/dtdsls400
-rw-rw---- 1 bsp app_ERP 11649 19. Jul 14:55 ddb61a9tes/dtdsls/dtdsls400
Both files are the same size because I removed the extra field in ddb61a9dev (company 300) after my test.
And here are the folder permissions:
drwxrws--x 2 bsp app_ERP 16384 19. Jul 15:28 ddb61a9dev/dtdsls
drwxrws--x 2 bsp app_ERP 16384 19. Jul 15:29 ddb61a9tes/dtdsls
|

22nd July 2019, 15:05
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
I have just run a complete rebuild of the dictionary (ttadv5210m000, +Check before create runt.) over b61a9tes and checked log.reconfig.
It says:
2017-09-22[12:17:44(UTC-02:00)]:bsp: Bdbreconfig check started by session ttadv5210m000 and pacc b61a9tes
2017-09-22[12:17:44(UTC-02:00)]:bsp: Bdbreconfig check, companies found to check:
2017-09-22[12:17:44(UTC-02:00)]:bsp: 100 102 200 201 202 203 204 205 400
2017-09-22[12:17:52(UTC-02:00)]:bsp: >>Start bdbreconfig check results:
...
2017-09-22[12:17:53(UTC-02:00)]:bsp: tdsls400100 C0 0 No reconfiguration is required
Then I ran the same session, limited to package "td", but with "Check before creating runt." unchecked.
This noew recreated the dict in dict/ddb61a9tes/dtdsls/dtdsls400, but the new field is still NOT present there, and in the oracle db the column has not been created.
|

22nd July 2019, 15:06
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Dear Ajesh, mark_h,
Thank you both for helping me with this!
I have tried again, doing these steps:
- Opened the table tdsls400 in ttadv4520m100 (Tools/App.Dev/Domains&Tables), - Added new field "fbtest", domain tc.ynna, default tcynna.no, no label.
- Convert to Runtime DD (+Reconfigure Tables, +Runtime Directories) in Session ttadv5215m000 over the whole of b61a9tes, all packages, all tables. Process prints no errors and finishes in <1 second, no messages shown.
The log directory does NOT contain a logfile log.ottadv5215!
I was also suspecting the permissions, but couldn't find anything wrong. Here's the two relevant files for tdsls400 in the two VRCs:
-rw-rw---- 1 bsp app_ERP 11649 19. Jul 15:20 ddb61a9dev/dtdsls/dtdsls400
-rw-rw---- 1 bsp app_ERP 11649 19. Jul 14:55 ddb61a9tes/dtdsls/dtdsls400
Both files are the same size because I removed the extra field in ddb61a9dev (company 300) after my test.
And here are the folder permissions:
drwxrws--x 2 bsp app_ERP 16384 19. Jul 15:28 ddb61a9dev/dtdsls
drwxrws--x 2 bsp app_ERP 16384 19. Jul 15:29 ddb61a9tes/dtdsls
|

22nd July 2019, 15:33
|
 |
Guru
|
|
Join Date: Feb 2009
Posts: 650
|
|
Baan: Baan IV -
DB: Oracle -
OS: HP-Unix
|
You can find the log by running "ttstperrlog" session from run Program. After that you need to select the specific log, as shown in the attached File.
Next , What is happening in the Runtime file in the OS?
In the ddb61a9tes/dtdsls/dtdsls400 file? Did you find your specific field "fbtest" in this file ?
|

22nd July 2019, 15:58
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Hi Ajesh,
thanks for asking.
I was looking for the log in the file system, where it wasn't. Checking in Session ttstperrlog: There is also no entry for log.ottadv5215.
The ddb61a9tes/dtdsls/dtdsls400 file is UNCHANGED, it does NOT contain my field "fbtest".
|

22nd July 2019, 17:05
|
 |
Guru
|
|
Join Date: Feb 2009
Posts: 650
|
|
Baan: Baan IV -
DB: Oracle -
OS: HP-Unix
|
Ask all users or disconnect all users from the system and then run create runtime for the whole package combination. I think because of the users being active on the system might be an issue. It happened in my case once.
|

22nd July 2019, 17:21
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Hi Ajesh, thanks for the tip.
I will try that. Though I am pretty sure nobody was connected when I tried it the last 15 times... 
Will let you know as soon as I have results.
|

22nd July 2019, 22:35
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,806
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
Ajesh - do you remember which tools tables that might need to be cleaned out for convert to runtime on tables? It seems to be we used to have an issue with that - we would have to clean out a table, then rerun convert to runtime to get it to work. Wondering if that might be an issue.
__________________
Mark
GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
|

23rd July 2019, 09:44
|
 |
Guru
|
|
Join Date: Feb 2009
Posts: 650
|
|
Baan: Baan IV -
DB: Oracle -
OS: HP-Unix
|
Quote:
Originally Posted by mark_h
Ajesh - do you remember which tools tables that might need to be cleaned out for convert to runtime on tables? It seems to be we used to have an issue with that - we would have to clean out a table, then rerun convert to runtime to get it to work. Wondering if that might be an issue.
|
Hi Mark
Its ttadv502(Tools company) for Table Def/Domains.
|

23rd July 2019, 17:18
|
Junior Member
|
|
Join Date: Jul 2019
Posts: 10
|
|
Baan: 61a9 -
DB: oracle -
OS: suse linux 11
|
Hi Ajesh,
even with nobody logged in, the problem remains the same.
I had already checked ttadv502. It does contain some rows for package combination b61au, but these I dare not touch. Please see my initial post where I have mentioned what happens to ttadv502 when I try to add the field.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|