YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

not Error Message Options · View
3859175
#1 Posted : Wednesday, January 11, 2012 7:37:23 PM
Rank: Newbie
Groups: Member

Joined: 1/11/2012
Posts: 2
Hi, I'm new with PI Oledb and I need some help
I'm trying to force the follow error: "Row insertion failed [PI SDK] Passed timestamp is in the future" that I'm getting with PIOLEDBTester, with my program developed in c#but when I run it it seems that it does insert, but when check it doesn't.

how can I capture or get the error?

the insert int PIOLEDBTester is:
INSERT piarchive..picomp2 (tag, time, value)
Select 'CA-068_WHP','16/01/2012 12:27:04:00 a.m.', 0
UNION
Select 'CA-068_WHP','16/01/2012 12:27:09:00 a.m.', 1
UNION
Select 'CA-068_WHP','16/01/2012 12:27:14:00 a.m.', 2
UNION
Select 'CA-068_WHP','16/01/2012 12:27:19:00 a.m.', 3
UNION
Select 'CA-068_WHP','16/01/2012 12:27:24:00 a.m.', 4
UNION
Select 'CA-068_WHP','16/01/2012 12:27:29:00 a.m.', 5
UNION
Select 'CA-068_WHP','16/01/2012 12:27:34:00 a.m.', 6
UNION
Select 'CA-068_WHP','16/01/2012 12:27:39:00 a.m.', 7
UNION
Select 'CA-068_WHP','16/01/2012 12:27:44:00 a.m.', 8
UNION
Select 'CA-068_WHP','16/01/2012 12:27:49:00 a.m.', 9

and is the same in c#

thanks a lot for your help, and sorry for my english, is not my natural language
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
squatty
#2 Posted : Thursday, January 12, 2012 7:26:34 AM
Rank: Advanced Member

Groups: Member

Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
Why are you trying to insert data with a timestamp in the future, today is 12-Jan-2012. It's not very good practice and it will produce out of order events on the pi server, or is it a typing error?
3859175
#3 Posted : Thursday, January 12, 2012 4:34:08 PM
Rank: Newbie
Groups: Member

Joined: 1/11/2012
Posts: 2
squatty wrote:
Why are you trying to insert data with a timestamp in the future, today is 12-Jan-2012. It's not very good practice and it will produce out of order events on the pi server, or is it a typing error?


I'm forcing that error because I want to get it in my program as I get it in pioledbtester

but in my program I don't get the error, it seems that the data insert ok, but when I look in PI, the data are not registered
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.