We seem to be having an issue with old “web only” versions. There are times when the “web only” version causes the other version to not egen correctly. So, below is the SQL that can be used to select the “web only” versions. SELECT count(*) FROM COPD811/F983051 WHERE VRVCC2='1' If you want to be more ...
The other day, I had a need to insert many records into the OCM (F986101). So I set out to create a quick SQL statement that would serve that purpose. Below is what I came up with: INSERT INTO SY811/F986101 VALUES('DV811',0,'OBJECTNAME','LOCAL','','*PUBLIC', '*ALL','P','','H95','AV','SQL','BSFN', 'USERNAME','','','',0,'',0,'','','','') Remember: you may have to make entries in both the SY811 and ...
To find out what users or groups have access to a certain environment run the following SQL: select * from sy811/f0093 where llll='<enviornment>' To find out what environments a user or group has access to run the following SQL: select * from sy811/f0093 where lluser='<userid>' ...
We have been having some issues lately where users create web-only versions and expect to use them after a full package has been built and deployed. We have processes in place for them to submit new versions to our development teams, but sometimes things dont happen the way they are designed. Anyway, I was doing ...
When setting up a workstation to perform the eGen process, once in a while there is a step that I seem to forget. It has to do with two settings in the JDBJ.INI file that need to be changed from their default values and JDBJ driver files: [JDBj-SPEC DATA SOURCE] This whole stanza needs ...
We ran into an issue when upgrading our EnterpriseOne Tools Release from 8.96.1.5 to 8.97.2.0. In order for the multi-threaded kernels to run correctly there is a setting in the JDE.INI file that needs to be set, SQLServerMode. The error that I was getting was like the following: ConnectDB:Unable to connect to DS ‘XXXXXXX – ...
Whether you are trying to change the processing options of an interactive version or a batch version. Sometimes you can run into issues where the application indicates that you do not have authority to change the version like the example to the left. To quickly get around this error, we can use SQL to change ...
We have our passwords set to expire every 90 days. Sometimes there are user IDs that you don’t want to change but don’t really want them to show up on the audit report as not having an expiration period. Here is a SQL statement that can help you: UPDATE SY811/F98OWSEC SET SCSECLST=<numeric date> WHERE SCUSER='<UserID>' ...
Over a year ago, I wrote about how to delete User Overrides in EnterpriseOne. Well, I had to use that process the other day and felt I should probably publish a fix to an unfortunate effects of using the User Overrides application. What are these effects? Well, when you delete a User Override, it is ...
Here is a really frustrating thing about some tables or files, depending on your IT dialect, with in EnterpriseOne. After working with EnterpriseOne for awhile (10 minutes should do) you will notice that the omniscient creators of the application did not like to make things easy. Take, for instance, the issue that Alan VanNice addresses ...