cancel
Showing results for 
Search instead for 
Did you mean: 

Time not matching

Ashutosh_Rawat
Rocketeer

I time in DB column is coming as it is in the incorta table from query level. I executed the same script in DB and Schema level and the time was matching. Once the tables are loaded in incorta I explored the schema and found out that the time in DB was no longer matching in Incorta table. I have verified there is no conversion going on at all levels, just bringing the datetime column from DB to Incorta. Please help!

2 REPLIES 2

RADSr
Captain
Captain

If this is as simple as the same row on the DB is not matching what is in Incorta you'll need to log a ticket. 

In the interim, try loading a singe row from the DB into a new Incorta table and see if that matches.   

It'd be helpful to see screen caps as well in order to suggest more troubleshooting options. 

-- IncortaOne@PMsquare.com --

It was just a data agent issue. Due to that issue there was a time lag of 5 hours in all our reports. Fixed by re-deploying the data agent.