Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
19%
200 - 500 GB
28%
500 - 800 GB
2%
800 - 1200 GB
7%
1200 - 1500 GB
7%
1500 - 2000 GB
12%
> 2000 GB
24%
Total votes: 83

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th December 2019, 23:33
dostach dostach is offline
Newbie
 
Join Date: Dec 2019
Posts: 2
dostach is on a distinguished road
Baan: baan 4 - DB: oracle - OS: Windows
Extracting Data from Baan
Baan: Baan IVc4
DB: Other/Unknown
OS: Windows 2012
C/S: Server

We have set up the BAAN Oracle Server (not sure which version of Oracle) at moment as a linked server in Microsoft SQL Server to do some data processing. We have having problems though as queries that include date field are returning errors:

for example:

SELECT [T$EITM]
,[T$REVI]
,[T$ORNO]
,[T$RELE]
,[T$INDT]
,[T$EXDT]
FROM [BAANSQL]..[BAAN].[TTIEDM100450]

returns the following error message

Msg 8114, Level 16, State 8, Line 2
Error converting data type DBTYPE_DBTIMESTAMP to datetime2.

I am seeking help since we are trying to do some data processing outside Baan for the data.
Reply With Quote
  #2  
Old 18th December 2019, 14:47
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,412
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I would be looking at how sql server treats the dates INDT and EXDT. There must be a disconnect between how oracle treats them and how sql server treats. I can't remember how they looked from oracle sql query and I no longer have access to query the database that way. Probably need to wait for someone to let you know how to define those date fields for that table in sql server.
__________________
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.
Reply With Quote
  #3  
Old 18th December 2019, 15:15
dostach dostach is offline
Newbie
 
Join Date: Dec 2019
Posts: 2
dostach is on a distinguished road
Baan: baan 4 - DB: oracle - OS: Windows
This seems to be issue with all date fields coming from the baan oracle database into the SQL server.
Reply With Quote
  #4  
Old 18th December 2019, 17:43
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,839
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Linked server !

Hello,

have a look at.

https://stackoverflow.com/questions/...ime2-data-type

Regards
__________________
//Bernd
Reply With Quote
Sponsored Links
Reply


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
Merino Services helps National Cables Industry archive data for Baan IV 100% off-site pritivandana Pages and Stories 0 4th March 2011 20:40
Extracting data from Baan varunnt86 Miscellaneous 0 24th September 2010 07:48
Import Excel data in BAAN (Ver IV) hunzian AFS/DDC/OLE: Function servers 2 19th November 2009 08:58
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 09:16
Fehlerhafte Rabattfindung in C4 Kai's Forum Users Deutsches Forum 2 9th January 2001 01:00


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


©2001-2018 - Baanboard.com - Baanforums.com