Hello,

I’m trying to secure the log in throught the webplugin in Monitoring and I thought about sending the password encrypted (as it seems to give me that option).

How could I make it since it sends nothing? (http://SERVER:1309/SentinelMonitoring.html?login=axway&pw=)

continue reading.....

Hi ya’ll,

I’ve made a query that gets the info from a specific row..

The query uses parameters to make the query and select the row.
I’ve tried with a simple query that has a normal where clause.
When trying to do that with another query (the one I want to implement with) that uses variables to make the request, it fails..

any idea?

continue reading.....

Hi,

Im have made the following statement for sql server :

update a set rescode=’OUTDATED’, completedate=getdate(), createuser=’INSTALL’ from [codafinprod].[dbo].oas_diary a where a.cmpcode=’101′ and RIGHT(a.actioncode,1) in (’1′, ‘2′, ‘3′, ‘4′) and a.completedate is NULL and a.cmpcode NOT IN
(select cmpcode from [codafinprod].[dbo].oas_docline b where
a.cmpcode=b.cmpcode and
a.elmcode=b.el2 and
b.statpay=84 and
b.el1=’400000′ and
(b.lettersev in (1,2,3,4)) and
(dateadd(day,-3,b.duedate) <= getdate()) and
((b.doccode=’XX-GEN’) OR (b.doccode like ‘SI%’)))

However when I try to do the same in xib I am having a problem with the alias “a”
xib does not accept the alias a after the update command
Does anybody know how to do this i a simple statement in xib?

Thanks

continue reading.....

Hi All,

Does InterPel (v6.6.0, for OS/400) supported by (or support) V6R1?

Thanks

continue reading.....

Hi folks!

I’m trying to make a query grouping by LocalID, it’s because I need just one row of 14.

Explain:

I request all transfers which state is TO_EXECUTE from a certain Client. The problem is that I need to make that query to Historic Table and that transmission has some tries and it retrieves 10-14 rows instead of one. All of them has the same values..

How can I get just one row? I’ve tried grouping bye and it doesn’t work, any ideas?

continue reading.....

Hey all,

I’m looking for ideas and demonstration purposes at trying to find some sample dashboards (really just screenshots) showing Sentinel’s capabilities. Does anybody have a dashboard or two they are proud of and could post a screenshot of it for me and let me know what you’re doing? I’m looking to show some of the possibilities but I don’t have any time just yet to create any, so your input and screenshots would be immensely helpful!

Thanks,
Tony

continue reading.....

Bonjour,

Je suis sur une Gateway, et un client CFT 2.6.3 essaie de se connecter en PeSIT/SSL.
Nous avons une erreur “Bad certificate” côté Gateway, et “Remote Issuer not found” côté CFT.

Quelqu’un a-t-il une idée pour savoir d’où vient l’erreur ? De la GW ou du CFT ?

Merci d’avance.

EDIT: Le problème venait du fait qu’il lui avait été fourni notre certificat “user” et pas “root”…

continue reading.....

Hello,

We are currently using CFT/MVS v2.32 with SSL. Our certificates are soon to expire, and our certificate provider has sent us new certificates. Unfortunately, the Root CA provided with the new certificates has been generated with a 4096 byte key, which apparently is not supported under CFT 2.32. We get the following error when importing the user certificate.

PKIU20I Error d2i_RSAPublicKeyPrimitive: KeyLenMod = 512
PKIU26E PKICER _ Error ( Signature check failed {15036/0} )

I have been browsing the documentation of CFT/MVS v2.4 and v2.6 but I cannot find any information about support for this. Has anyone using CFT/MVS v2.4 or later encountered this problem?

Best regards,
Sebastian Dewar

continue reading.....

Hi folks,

As you may know I’d made a query to retrieve information depending on the client the user had chose.
I’ve seen that the query is slow, probably because it’s an union of too amny queries and it takes time. I’m thinking about changing it to request the information once depending on the value of the parameter instead doing all that work.

So, I’m trying to carry out a query like this:

If TrkParameter(Client) = “ClientA” then
Select queryA
elseif TrkParameter(Client) = “ClientB” then
Select queryB
.. so on

I cannot make it.

ps:
I also tried like this:
if select ‘TrkParameter(Cliente)’ from dual = ‘ClientA’ THEN
select ‘ClientA’ FROM dual
ELSE
select ‘another’ from dual
END IF

and won’t get anything but a server error (as all tries)

have a nice day!

continue reading.....

Dear All,

We are facing some issues with new SFTP connectivity to our client.
we could estalish the SFTP connectivity manually using SFTP protocol from Backend. But when the same is configured in Gateway front-end we are facing issues with connectivity and getting the following error “Algorithm identifier (ssh-rsa) is not compatible with the one requested (ssh-dsa) check configuration”
please help..

Regards,
Satish

continue reading.....