[Feda Birani]

In case anyone needs this. Found that this worked for me.

I did migrate first. I believe you can do this on 6.2 before you move it or on new 2022.

Hcismatcrypt migrate (your smat file name from 6.2) (key which is usually your site on 6.2)

after I ran above, I moved migrated smat file from 6.2 to 2022 directory and changed encryption key to be the new 2022 site
Hcismatcrypt rekey (your new 2022 site name) (6.2 key passowrd which is usualy the 6.2 site name) (smatfile name from 6.2) (new encryption key which would be your 2022 site name) (here you can keep empty if you want your smatfile name to remane the same or provide a new file name I’m assuming, i left mine the same)

[Feda Birani]

Hi Charlie,

I’m on 6.2 going to 2022.09, trying to use the command hcismatcrypt migrate and I’m stuck. If I take 1 smatfile from site A on 6.2 and move it to site B on 2022.02, place it in the exec file on site B, what should my command look like? On site A the encryption key is the site name, on the site B the encryption key will be site name, however site name is diff.  I have many files that need to be migrated, so trying to figure out the best way to do this. I need to be able to search these 6.2 smats within 2022.09 for a few months, then I move them off line for also another few months, I sometimes have to pull back from offline to live, etc.

[Feda Birani]

Jim,

I’ve started to look at Global Variables and a bit stumped. From your investigation I now know there is 2 options,  in-memory and .ini. I thought and now not sure, I was using .ini all along.  I’m trying to store the newest token in the .ini. I do this by changing what is originally in the .ini (manually added) by doing the following

[gvdelvar token]

gvsave

[gvaddvar token $token] (notice not using $$prefix – still uncertain what $$prefix does. Is this used for in memory?)

gvsave

This works and I see the .ini get updated when i open the gui tool.

However, my issue is now trying to read what I’ve put in  [hcigetvar token] on the reply tcl (diff tcl then where i added to .ini).  Says variable not found.  This makes me think it’s something to do with memory because I’m able to do [hcigetvar token] successfully, if i put it in the same tcl I added it.  I feel like I’m not understanding something.

How do you use the in memory, not ini and at what point do you loose what’s in memory?

How do you add/update & get from the .ini. I’m using the site gv.ini not master site, so assuming no other site would be affected, only what sits in this one site. Also, did you find any slowness when GV was used?

[Feda Birani]

Thanks again Peter, Not sure what I’m missing, keeps telling me same thing “Only SELECT statement is allowed in DBLookup”. Could it be the version i’m on? 6.2.4?

[Feda Birani]

Hi Peter,

Thanks for the quick response. I don’t believe an insert stored procedure within a lookup table is allowed? I receive “Only SELECT statement is allowed in DBLookup”

I’m hoping for the same idea via tcl script.  {?=CALL stored procedure( all passed in elements to insert)};

Thoughts? else resorting back to the same ODBC dbconnect run insert query etc….

 

[Feda Birani]

Hi Bill,

I noticed your setting the webClientFactory key in USERDATA. Your not putting this in httpRequestInfo, so assuming its not cloverleaf that requires it? Are you using it so you can reference it from your tcl logic? I’m having issues on my end and trying to decipher whether I need it for my 1 raw_consumer or not.

I’m having an issue setting up a rawclient/post that has CA certificates in a keystore located in a file/directory .  I’ve added a conduit to set tls tab with the keystore/truststore location/password. msgdump shows that my USERDATA has the httpRequestInfo with url, post and content-type etc that i need. However, when the JSON message is trying to send, i receive the below errors

{exception {{level send} {cause No\ message\ body\ writer\ has\ been\ found\ for\ class\ java.io.ByteArrayInputStream,\ ContentType:\ application/xml} {stackTrace javax.ws.rs.ProcessingException:\ org.apache.cxf.interceptor.Fault:\ No\ message\ body\ writer\ has\ been\ found\ for\ class\ java.io.ByteArrayInputStream,\ ContentType:\ application/xml\r\n\tat\ org.apache.cxf.jaxrs.client.WebClient.doResponse(WebClient.java:1149)\r\n\tat\ org.apache.cxf.jaxrs.client.WebClient.doChainedInvocation(WebClient.java:1094)\r

inaryDataProvider.copyInputToOutput(BinaryDataProvider.java:194)\r\n\tat\ org.apache.cxf.jaxrs.provider.BinaryDataProvider.writeTo(BinaryDataProvider.java:154)\r\n\tat\ org.apache.cxf.jaxrs.utils.JAXRSUtils.writeMessageBody(JAXRSUtils.java:1381)\r\n\tat\ org.apache.cxf.jaxrs.client.AbstractClient.writeBody(AbstractClient.java:477)\r\n\t…\ 10\ more\r\nCaused\ by:\ sun.security.validator.ValidatorException:\ PKIX\ path\ building\ failed:\ sun.security.provider.certpath.SunCertPathBuilderException:\ unable\ to\ find\ valid\ certification\ path\ to\ requested\ target\r\n\tat\ sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:397)\r\n\tat\ sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:302)\r\n\tat\ sun.security.validator.Validator.validate(Validator.java:262)\r\n\tat\ sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324)\r\n\tat\ sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229)\r\n\tat\

PKI certs added and I’m able to send a successful json message through soapui, so it has to be my thread setups that is the issue. Any help would be appreciated.

[Feda Birani]

Hi Marla,

Thanks for the info. Where can i get my hands on this dtcsample site? Did you have to go to Infor directly for it or is it hidden here somewhere and i can’t find it? I’m currently on ver 6.2.4 and it’s not a sample site that comes with it. Thanks,

Feda

[Feda Birani]

Thanks Charlie, I got it. I was overthinking it and not realizing I was picking the wrong message handle.

[Author]

Replies