Edit Place Overview Page

Subject		Author
	Function name 'GETDATE' is invalid. 3 days ago	by GabrielLucas
	What types of Files can a PI UFL interface read and Process? 3 days ago	by Rhishabh.Singh
	Connecting new PI DA to AF through NLB 3 weeks ago	by LaineTedder
	Is it possible to edit tag security in bulk periodically so that Data Archive doesn't get loaded 3 weeks ago	by Rhishabh.Singh
	can't see any interface in ICU when open the pull-down box 4 weeks ago	by ChenJi

Loading...

Recent Activity

Filter

Set as default view

Filtered by:All Items

Rhishabh.Singh in PI Server3 weeks ago (Show more Show less)

What types of Files can a PI UFL interface read and Process?

Hi PI Folks I wanted to know what different types of file format a PI UFL interface can read and process, I am aware that it can process.txt,.csv(ascii). Can anyone of you please provide the details? Regards Rhishabh

in PI ServerLike Show 0 Likes(0)

3 repliesShow more activityShow more activity

avanfosson (to Rhishabh.Singh) 3 days ago (Show more Show less)

According to the documentation, the PI UFL interface can read text from: ASCII files on Windows drives Serial ports Email servers through the Post Office Protocol 3 and Post Office Protocol Secure (POP3 and POP3S)

Like Show 0 Likes(0) Actions

GabrielLucas in PI Server4 days ago (Show more Show less)

Function name 'GETDATE' is invalid.

I am not able to perform variable declarations, nor use any functions within SQL Commander Lite.

in PI ServerLike Show 0 Likes(0)

3 repliesShow more activityShow more activity

jyi (to GabrielLucas) 3 days ago (Show more Show less)

PI OLEDB Provider is in accordance of ANSI SQL 92 Entry-level standard. And getdate() isn't simply one of them. Please see below for the supported function list: PI OLEDB Provider - Date/Time functions As Pedro Barroso showed above, we have a much easier method to get datetimes.

Like Show 0 Likes(0) Actions

LaineTedder in PI Server3 weeks ago (Show more Show less)

Connecting new PI DA to AF through NLB

I am installing the AF Servers (AF Application Service) on two servers behind a NLB. When configuring the new DA is it best to select one of the AF Servers directly or use the AF Server entry in the NLB it that way the NLB will always broker the connection to an individual AF Server.

in PI ServerLike Show 0 Likes(0)

4 repliesShow more activityShow more activity

LaineTedder (to LaineTedder) 3 weeks ago (Show more Show less)

Thank you for the confirmation.

Like Show 0 Likes(0) Actions

Rhishabh.Singh in PI Server3 weeks ago (Show more Show less)

Is it possible to edit tag security in bulk periodically so that Data Archive doesn't get loaded

Hello PI Folks, I have to edit the security settings of 100k pi tags,need to add an identity,Is it possible to edit these tags in bulk periodically so the data archive server doesn't get loaded. For example -Edit 500/1000 tags and then wait 5 minutes or some amount of time ,post waiting ,edit next batch of tags and keep on doing so until all the… (Show more Show less)

in PI ServerLike Show 0 Likes(0)

0 replies

annurawat in PI Server3 weeks ago (Show more Show less)

[-10774] No Certificate found while creating Collective

I am getting error [-10774] No Certificate found matching the specified parameters while creating Collective please help

in PI ServerLike Show 0 Likes(0)

1 replyShow more activityShow more activity

skwan (to annurawat) 3 weeks ago (Show more Show less)

If you have Data Archive 2017 or newer, you need a certificate for communication between collective members. LiveLibrary topic here: PI Server

Like Show 0 Likes(0) Actions

ChenJi in PI Server4 weeks ago (Show more Show less)

can't see any interface in ICU when open the pull-down box

We want to update the configuration of an OPC DA interface in ICU in a remote server, but we can't see any of them in ICU when we open the pull-down box. I think it must be the security issue of the account which was used to login the remote server, but please help us to find the way to solve it. Anyone having an idea how to resolve this… (Show more Show less)

in PI ServerLike Show 0 Likes(0)

2 repliesShow more activityShow more activity

Cédric Canguilhem (to ChenJi) 4 weeks ago (Show more Show less)

Hi Ji Chen ! Did you try to select the option "Load interfaces from a selected list of PI servers" which you can find under "Tools > Options > Loading" ? : I think the top one is selected by default.

Like Show 0 Likes(0) Actions

Maitreyi in PI Server4 weeks ago (Show more Show less)

Power shell script issue

Hi there, WE have a dedicated PI interface server. I'm trying to run a basic Power shell script to connect to the PI server and get the PI value from the archive. Using the command Connect-PIDataArchive -PIDataArchive "PIServername" When I run the power shell script, it spits out with the following error message: Connect-PIDataArchive: The… (Show more Show less)

in PI ServerLike Show 0 Likes(0)

4 repliesShow more activityShow more activity

James Devine (to Maitreyi) 4 weeks ago (Show more Show less)

Hi Maitreyi Sathyanathan: If you are needing to start from the beginning the OSIsoft.PowerShell library gets installed with the PI System Management Tools (PI SMT) installation kit. If you have that installed on your workstation, then the library should be available to you. Again, at the prompt you can type "Import-Module OSIsoft.PowerShell".…

Like Show 0 Likes(0) Actions

Georgio in PI Server1 month ago (Show more Show less)

Como posso estar criando um Servidor de teste PIWeb API?

Estou realizando uma integração de dados, usando c# e preciso realizar alguns testes, como o retorno do GET do WEBID, e preciso criar um servidor de teste, por favor conseguiriam me orientar.

in PI ServerLike Show 0 Likes(0)

3 repliesShow more activityShow more activity

James Devine (to Georgio) 4 weeks ago (Show more Show less)

Your access to a developers set of downloads depends on the sales agreement between your organization and OSIsoft. If you are not a PI Admin with access to the OSIsoft product downloads page at your organization, you may have to contact that person internally, or simply call OSIsoft Tech Support and they can help you navigate your download. …

Like Show 0 Likes(0) Actions

tombayu.hidayat in PI Server2 months ago (Show more Show less)

Data stream error between UFL Connector and Data Archive

Hello,In the past few days I was busy with connecting new data sources to our PI system. We mainly use the UFL connector to achieve this. We notice that the incoming data is quite a lot, so after creating some new data sources in the UFL Connector we got an message saying that the number of licensed PI points have exceeded. To overcome this, I… (Show more Show less)

in PI ServerLike Show 0 Likes(0)

1 replyShow more activityShow more activity

mhruzik (to tombayu.hidayat) 4 weeks ago (Show more Show less)

Hi Tombayu Amadeo Hidayat, haveyou been able to resolve this issue? The error comes from the framework so it looks like you really reach the limit.

Like Show 0 Likes(0) Actions

vwitzel in PI Server1 month ago (Show more Show less)

Data Backfill Options & Considerations

Hi all, We need to do a one-time ingest of a large volume of time-series data spread across a large number of CSV files (there will likely be one file per tag) into a single PI Data Archive server. While some of the data will flow into new PI tags and resultingly come into PI in order, other data will flow into existing tags as out of order (OOO)… (Show more Show less)

in PI ServerLike Show 1 Like(1)

19 repliesShow more activityShow more activity

Roger Palmen (to skwan) 4 weeks ago (Show more Show less)

I like internal tool... I want internal tool! But seriously, in another thread this topic was also covered. There is no way to bulk import or export data except for the options given. And what has been discussed, that direct access to the archive files could be a way to do some big-scale exports or imports of data what are becoming more common…

Like Show 0 Likes(0) Actions

Load more items