Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 16th July 2004, 09:58
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Losed tfgld418 records - Urgent Help Please

We ran ttaad4225m000 session on 9th of July for our live company. (We ran it because the system performance of our windows server was terribly slow.... Before once we did it and the performance came back to normal)
Yesturday we faced some problems when processing hours accounting and during investigation we have noted that nearly 90% of the records are missing from tfgld418 tables.

The record count of tfgld418 should be nearly tfgld417+tfgld410.

In our case
tfgld410 2333477 records
tfgld417 2333184 records
tfgld418 391922 records should be tfgld410+tfgld417 about 4670000

We saw the transactions date of the existing records in tfgld418 and they are from 10th july...We losed tfgld418 records during reconfig!!

To solve our current problem and to go ahead with our day to day transactions we have to rebuild tfgld418 table.
Baan support mentioned that it is impossible to rebuild tfgld418 completly.

Unfortunately we dont have the backup for this company. The last back up what we have is of 8th June.

Need your help to solve this problem

Note that this live company is running on windows and Baan 5c corelli.

Few clarifications

1. straight forward...How important are the tfgld418 records... Can we continue our business without rebuilding them... Where exactly it will affect our business... Where in finance and where in logistics...What reports may give us wrong output... what business process may fail

2. We have few records(around 2000) in the tfgld416 (Non posted integration transactions) which are before 10th July. The records are related to transactions Sales/Issue (transaction origin/Financial transaction) and Sales invoicing(sales)/Cost of Goods sold. Can we post them without tfgld418?

3. Is it possible to rebuild tfgld418 table (may be from tfgld410, 417 and tfgld106 or any other table).
If so from which tables... What fields cannot be rebuilded...and what will be the affect of those missing field values in the business (I came to know for example that the document number will be difficult or impossible to rebuild....)

4. During reconfig is there any file where system writes these rejected records so that we can retrieve them from there

5. What are the files which tells us the exact number of rejected records from the tables during reconfig...so that we can make sure that only tfgld418 table is affected

Any other suggestions?

Thanks in advance
  #2  
Old 16th July 2004, 15:43
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
answers

Q1 - tfgld418 is the support for integration postings in finance. Auditors can vouch this integration reports with postings in finance. Without records in tfgld418 this will not happen. Baan standard archiving will not work.

Q2 - posting can not be done without records in tfgld418.

Q3 - Techncally possible but extremely difficult and not advisable.

Q4 - Normally the records are not lost in re-org except when u check validity of reference and repair references. I think in ur case u rebuild the data and indiced and the rebuild process seems to have been aborted . In such case there should be some R.tfgld418 file in the tmp folder. And u should be able uploda the date from thereon after appropriate backup.

Q5 - log.aad4225

Hope this helps.
  #3  
Old 17th July 2004, 16:14
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Thanks for the detail answers.

This problem really happened few weeks back..but we discovered it only yesturday. We delete all the files in the tmp folder everyweek (Because it generates hell lot of files everyday) and we never kept the back up. I searched $BSE/log and $BSE/tmp folder and the only file we can able to get is aad4225.log. (I also searched for any files in the document and setting/user/local settings/temp folder but didn't find any) Is there any other location I can search for the related files?

I tried to analyse aad4225.log but couldn't understand anything. Is it possible to verify what other tables affected from this file (I have attached the file)

The only option now left is of rebuilding tfgld418. Any suggestions from which tables I can collect the data from
Attached Files
File Type: zip aad4225.zip (3.49 MB, 29 views)
  #4  
Old 20th July 2004, 17:07
kumaresan_r kumaresan_r is offline
Junior Member
 
Join Date: Jul 2004
Location: India
Posts: 28
kumaresan_r is on a distinguished road
Baan: ERP LN 6.1, Baan IV - DB: Sql - OS: Windows
Hi,

I think the table tfgld418 can not be brought back in your case. But, without this table, you can manage by generationg a report with a combination of tfgld410 and tfgld417.

But in case of unposted transactions (tfgld416), the records should be in tfgld418 for posting, you can insert missed records through GTM in tfgld416 and post.

Regards
  #5  
Old 21st July 2004, 08:08
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
points to remember

Quote:
Originally Posted by kumaresan_r
Hi,

I think the table tfgld418 can not be brought back in your case. But, without this table, you can manage by generationg a report with a combination of tfgld410 and tfgld417.

Regards
If u generate a new report , sales invoices are present only in tfgld410 . It does not exist in tfgld410. Further integration status tfgld410.sint is not updated (we have SP12 loaded).
  #6  
Old 21st July 2004, 10:12
pfsilva's Avatar
pfsilva pfsilva is offline
Member
 
Join Date: Apr 2002
Location: Portugal
Posts: 91
pfsilva is on a distinguished road
Baan: BaanIVc4 -
Hi,
Maybe u have a way to recover tfgld418 missing records using tfgld410...as u may have noticed records in tfgld410 relate to tfgld418 in the following way:
tfgld418.ocom=tfgld410.ocom
tfgld418.tror=tfgld410.tror
tfgld418.fitr=tfgld410.fitr
tfgld418.trdt=tfgld410.trdt
tfgld418.trtm=tfgld410.trtm
tfgld418.sern=tfgld410.sern
tfgld418.line=tfgld410.line
tfgld418.ttyp=tfgld410.ttyp
tfgld418.docn=tfgld410.docn
tfgld418.fcom=tfgld410.fcom
tfgld418.lino=tfgld410.lino
tfgld418.cprj=tfgld410.cprj
tfgld418.prin as no equivalent in tfgld 410 but is normally = tcyesno.no
tfgld418.sint is set to tfgld.sint.posted if tfgld410.podt <> 0(empty) else is unposted or erroneous
tfgld418.tmpk=tfgld410.tmpk

The main index is the same, so u can rebuild tfgld418 from tfgld410 with this criteria...
Maybe u should try it first with existing records in both tables to check if your script would generate correct records for tfgld418 out of tfgld410...
Hope this help.
Regards,
Pedro
  #7  
Old 21st July 2004, 14:40
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 133
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
tccov0207m000

I have seen this session but never used it. Session description is "Fill tfgld417 and tfgld418 based on tfgld410". Maybe this is of use to you.
__________________
Gary
Sponsored Links
  #8  
Old 21st July 2004, 17:30
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
tfgld418 = tfgld410 + 417

Hello,

We made a specific for this problem.
I can send it if you still need it.

Regards
  #9  
Old 22nd July 2004, 17:15
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Trying the options already mentioned in the thread...

Richard can you please send me the details

Please note that we are on Baan5 corelli

Thanks a lot
  #10  
Old 22nd July 2004, 17:24
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
There is lot of changes on these tables between baan4 and baan5c. Anybody done this for Baan5c. Or atleast can anybody help me to get the field by field mapping for tfgld418.
  #11  
Old 23rd July 2004, 10:11
mprakash mprakash is offline
Member
 
Join Date: Jun 2004
Posts: 38
mprakash is on a distinguished road
Baan: Baan 5c - DB: Oracle, sql 2000 - OS: unix, windows2000
Field mapping of tfgld418

I made a xl file to map the fields of tfgld418. So far I was able to get only the index part!!! May you guys help me to fill the fields (those you can) in the xl sheet!!! (column is marked in red color)

I like to finish this job today!! so your quick help will be much appriciated.

Thanks guys
Attached Files
File Type: xls tfgld418-mapping.xls (21.5 KB, 44 views)
  #12  
Old 23rd July 2004, 15:47
raja100 raja100 is offline
Newbie
 
Join Date: Mar 2004
Posts: 2
raja100 is on a distinguished road
Baan: BaaN Vc - DB: Oracle - OS: Unix
Losed tfgld418 records

Hi,
Copying data from 410 and 417 only is not going to help, there are some fields in 418 for which data needs to be pulled from other table. The complicated one is the order number. I need to ask u some more questions send me a separate email and i will send u my contact number for discussing this.

Regards
Arun
  #13  
Old 3rd August 2004, 16:02
Mohamed_alsadr Mohamed_alsadr is offline
Member
 
Join Date: Dec 2003
Location: Cairo,Egypt
Posts: 86
Mohamed_alsadr is on a distinguished road
Baan: 5.0c - DB: SQL - OS: 2000/2003 sever
actually there no serious problem regarding your process it is a problem that appears only when you print the financial integration history data and if you want to rebuild ,you have to see the integration scheme and make the same procedure which used by baan to build this tables
  #14  
Old 25th September 2004, 09:26
ritchly's Avatar
ritchly ritchly is offline
Junior Member
 
Join Date: Sep 2003
Posts: 6
ritchly is on a distinguished road
Baan: BaaN IVc4 - DB: MS SQL 7.0 - OS: Windows NT 4.0
run correctin programme otfcor0232

Check the correction programme otfcor0232

regards
rona;d
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Select distinct records thru query extension?? arajasek Tools Development 5 25th August 2010 07:24
CUMULATING + FILTERING records in DISPLAY SESSION en@frrom Tools Development 21 25th August 2003 16:16
tfgld418 Eddie Monster Tools Development 7 18th November 2002 21:11


All times are GMT +2. The time now is 20:13.


©2001-2017 - Baanboard.com - Baanforums.com