User login
|
|
|
|
Frontpage Sponsor
|
|
|
|
Poll
|
I manage and monitor my Baan server/application with HP Openview 7% IBM Tivoli 14% BMC Patrol 2% Nagios 11% Other 30% What are you talking about? 37% Total votes: 120 |
|
Baanboard at LinkedIn
|
|
|
|
 |
22nd December 2009, 12:29
|
|
Senior Member
|
|
Join Date: Oct 2003
Location: Cantabria - Spain
Posts: 264
|
|
|
Baan: B50b -
DB: DB4 -
OS: OS400, UNIX
|
No data after index creation
Baan: iBaanERP 5.0b C/S: None/Unknown
I create a new index in tdsls401, but when I try to access data throught this index there is no records with ttaad4100. If I access data with another index there is no problem.
This problem is only in one company the other ones go well.
What is the problem? How I repair it?
Thank you in advance,
__________________
Regards,
monica
|
22nd December 2009, 13:52
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
|
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
|
Did CRDD get completed and did you log out and back in? Sounds like you did, but thought I should mention it. You can try ttaad4225m000 to repair and re-org the table.
__________________
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 December 2009, 13:58
|
|
Senior Member
|
|
Join Date: Oct 2003
Location: Cantabria - Spain
Posts: 264
|
|
|
Baan: B50b -
DB: DB4 -
OS: OS400, UNIX
|
|
Options
what options do I have to check? Only Data and Indexes?
__________________
Regards,
monica
|
22nd December 2009, 15:42
|
|
Guru
|
|
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
|
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
|
I usually run it with Data and indexes, plus reference integrity and repair reference counter. I also have only run this in test companies and our app admin runs in production.
__________________
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 December 2009, 16:05
|
|
Senior Member
|
|
Join Date: Oct 2003
Location: Cantabria - Spain
Posts: 264
|
|
|
Baan: B50b -
DB: DB4 -
OS: OS400, UNIX
|
|
It is necessary that everybody is out of baan to do it?
Thank you very much
__________________
Regards,
monica
Last edited by monica1 : 22nd December 2009 at 16:25.
|
22nd December 2009, 17:00
|
|
Guru
|
|
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,016
|
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
|
As far as I know - yes. They should be out of Baan. I would run it in test first. This basically unloads the table and reloads the table.
__________________
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 December 2009, 04:42
|
|
Member
|
|
Join Date: Oct 2008
Posts: 31
|
|
|
Baan: Baan IV, Baan ERP, BaaN ERP (B50C) -
DB: MS SQL 2000, Oracle, Informix -
OS: Windows 2003, Unix
|
|
What are the index fields in new index?
and does this index allows "Duplicates" ?
|
23rd December 2009, 08:51
|
|
Senior Member
|
|
Join Date: Oct 2003
Location: Cantabria - Spain
Posts: 264
|
|
|
Baan: B50b -
DB: DB4 -
OS: OS400, UNIX
|
|
No, it is not duplicate. The new index has cwar + index1.
Thank you
__________________
Regards,
monica
|
28th December 2009, 13:35
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 17
|
|
|
Baan: BaaN 4c,5c, Infor LN -
DB: SQL, Oracle -
OS: Windows Xp
|
|
Hi,
As per your query This problem is only in one company the other ones go well.
can you be more specific. Is your logistic table is shared through out all company.
If it is so than you have to take sequential dump of table from all company and delete tables. then re-configure and re-login and create table.
__________________
Thanks & Regards
Ranjan Kumar
|
28th December 2009, 18:37
|
 |
Guru
|
|
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,266
|
|
|
Baan: All -
DB: Oracle / MS SQL / DB2 -
OS: All
|
|
Can you see the index in DB4?
Are there any errors in your log.<driver> or log.reconfig files?
It could just be the shared memory and restarting baan might fix it. or (i'm not 100% sure on AS400 but i think DB4 is level 1 driver) in which case that index might not have gotten created correctly.
Dave
|
|
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
|
|
|
|
