Published in December 21st, 2010
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=)
Published in December 20th, 2010
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?
CODE
with t as (SELECT FIELDS FROM SOMEWHERE
ORDER BY SOMETHING)
select * from (select rownum as Fila,LocalId,State,SenderId,ReceiverId,StartDate,StartTime,EndTime,ProtocolFileN
ame,FileSize,Protocol
from t)
where Fila = 7
Published in December 20th, 2010
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
Published in December 17th, 2010
Hi All,
Does InterPel (v6.6.0, for OS/400) supported by (or support) V6R1?
Thanks
Published in December 17th, 2010
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?
Published in December 15th, 2010
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
Published in December 14th, 2010
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.
CODE
10/12/14 16:25:02 CFTY02Z >> CTX=200063 Remote Issuer DN = /C=US/O=Thawte, Inc./CN=Thawte SSL CA
10/12/14 16:25:02 CFTY02Z >> CTX=200063 Remote Serial Number dump
10/12/14 16:25:02 CFTY02Z >> CTX=200063 7E0A9BD3 8A02267C 21820B24 800AAF64 >...............d<
10/12/14 16:25:02 CFTY02Z >> CTX=200063 00000000 00000000 00000000 00000000 >................<
10/12/14 16:25:02 CFTY02Z >> CTX=200063 00 >.<
10/12/14 16:25:02 CFTY02Z >> CTX=200063 Remote Issuer not found
10/12/14 16:25:02 CFTY02Z >> CTX=200063 cftpki() _ PKII PHASE=CHKCERT CR=1 REASON=42
10/12/14 16:25:02 CFTY18E CTX=200063 INTERNAL PKI ERROR PHASE=CHKCERT REASON=42
10/12/14 16:25:02 CFTY02Z >> CTX=200063 SSLact() _ SENDING 7 ALERT DATA
10/12/14 16:25:02 CFTY02Z >> CTX=200063 15030100 02022A >.......<
10/12/14 16:25:03 CFTY18E CTX=200063 Check_Certificate error
EDIT: Le problème venait du fait qu'il lui avait été fourni notre certificat "user" et pas "root"...
Published in December 14th, 2010
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
Published in December 13th, 2010
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!
Published in December 6th, 2010
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
