IFS is unusually slow, to the point you can no longer use lobby elements or perform simple query's. For instance the same query/lobby takes less than 5 seconds on Production and on the Satellite its takes up to 5 minutes. The database ran the Query in a couple of milliseconds.Some further information:1. No network issues, there server runs on a local network onboard.2. slowness it experienced everywhere in the APP particularly Active Work Orders and Measurement Registration when loading records greater than 100 lines.3. I am performing simple query's such as select MCH_CODE, PARAMETER_CODE, TEST_PNT_SEQ from EQUIPMENT_OBJECT_NEW where MCH_CODE like '3111%' and PARAMETER_CODE = 'ALARM' 4. The environment was restarted last Friday however no changes were made5. This issue was noticed last week6. There is very low resource usage in the MWS i.e CPU less than 5%We refreshed the Server yesterday as well as cleared the dictionary cache. Anyone have similar issues or have any solutions? Many t
Hi All, I am trying to implement a custom field so our users can see some historical information on work tasks. I can get the SQL to work using the SQL query tool, my issue seems to be with my arguments. My code is as follows:Argument:v.source_ref1Select Statement:select * from (select performed_work from jt_task_CFV where (state like '%Done' or state like 'Finished') and source_ref1 =: source_ref1 order by TASK_seq desc ) where rowNum = 1The error I receive is “The Column source_ref1 referred to in table t is not an approved persistent Custom Attribute”Any assistance would be much appreciated.
Hi,I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing two issues:1. Testpoints: for some reason I cannot migrate into the custom fields I have set up on Testpoints (EQUIPMENT_OBJECT_TEST_PNT). Any idea’s why the migration job will not let me migrate into my persistent custom fields?2. Parameters: When I run the second method of my migration job (EQUIP_OBJ_PARAM), it updates the Parameter for the Default testpoint not my newly created Testpoint. Anyone had a similar issue or has a solution? Any help would be much appreciated. Thanks,Harry
Hi,I’m just trying to create a simple Read only attribute on a Custom Logical Unit that fetch’s a field from JT_TASK. Could someone please assist, I am not sure what I am doing wrong? Any help would be much appreciated. Using the SQL Query Tool I can get the SQL to work.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.