isaque.almeida

Hi experts, after I migrate mdb and CA SDM from server (source and target version 17), when search incidents, the list does not load and when search by especific numbers it is not found as you can see attachments. Checking stdlogs I discovery this search is trying to execute a query with columns wich does not exist in call_req table. for example: call_req.actual_comp_date , call_req.current_wrkshft , call_req.est_comp_date , call_req.start_date. Just to check if it works, I create these fields in SQL Design and it works. However other problems like that happen. Can someone help me to understand what may have happened? After install SDM in the new server I follow this procedure strictly: https://docops.ca.com/ca-service-management/17-1/en/administering/moving-the-ca-mdb-data-from-the-source-to-the-target-systems I also attached some piece of stdlog.stdlog.txt stdlog.txt

Hi, after a lot of tries it worked like this: type != 'I' AND group = U'A9CD563B7420B747929459DC8F91C645' We are denying Incidents for this the group. Thanks for your efforts henning1518. I appreciate it. Good lucky

Hi Hennig, Thanks for helping however when I create a constraint only with "Type != 'I'" it restricts all incidents, even for other groups.

Hello Service Desk Experts, I need to restrict users open Incidents for a Specific group. Only for incidents, request should works. So I'm trying to do this by Data Partition constraint of creation. Eg. Type: Create Table: Call_Req Constraint: type != 'I' AND group != U'A9CD563B7420B747929459DC8F91C87' ***My problem is that this constraint is blocking not only Incidents, but also Requests.*** I already try something like that but it also blocks Requests too. type != 'I' AND group.last_name != 'name_of_the_group' (type != 'I') AND group.id != U'A9CD563B7420B747929459DC8F91C645' I would appreciate if someone can help to achieve that. Thanks in advance.

Hi Black, thanks for responding. I move the code to detail_alg.htmpl, so the validation can be done on the resolution moment. Thanks again. Hugs.

Hi experts, I have the list of symptom codes on my usp_symptom_code table as follows: id del sym 900 0 Application Not Responding 901 0 Error Message 902 0 High CPU Usage 903 0 Slow Response 904 0 System Making Noise 905 0 Unable to Connect 906 0 Unable to Log in 907 0 Unexpected Results 908 0 Unable to Boot 400001 0 Phone Not Responding 400002 0 Phone Error Message 400003 0 Phone Password Forgotten 400004 0 Phone Slow Response 400005 0 Phone Unexpected Results 400006 0 Phone Unable to Start What I want to dos is: When I open a new incident, if choose some category like 'HARDWARE.CELULAR%' just symptom codes related to it appears. This is my code on "detail_in.htmpl": var catCelular = 0; <PDM_LIST PREFIX=celularList WHERE="ref_num = '$args.ref_num' AND category.sym LIKE 'HARDWARE.CELULAR.%'" FACTORY=cr> // $celularList.id catCelular = 1; </PDM_LIST> if(catCelular == 1) { <PDM_MACRO name=dtlDropdown hdr="Symptom" attr=symptom_code lookup=no whereclause="id IN (400001, 400002, 400003, 400004, 400005, 400006)"> }else{ <PDM_MACRO name=dtlDropdown hdr="Symptom" attr=symptom_code lookup=no whereclause="id IN (900, 901, 902, 903, 904, 905, 906, 907, 908)"> }; When I create a new incident, before I choose some category it is ok, it is showing only symptom codes not related to category 'HARDWARE.CELULAR%' but when I choose one of these categories the options are not filtered. I hope I was able to be clear, I will be thankful if someone could help me on this. Thanks in advance. Bye.

Hi SDM experts, I'm very newbie on SPEL code. if ( !is_null(assignee) && status == "OP") { status = "WIP" ; How can I change it into a SPEL code? I want that SPEL code check 'assignee' field, if it is not null and it status is equal to 'Open', so set status to 'Work In Progress'. I'm talking about cr object. Can you guys help me?

Hi guys. On the Knowledge Documents Categories in Knowledge tab on SDM we have folders and subfolders created to put documents. Some of them have documents other does not. Well, what I need is a SQL Query to show how many docs we have in each folder or at least show if folder is empty. Do you guys know how it is possible? If somebody can help me I would appreciate it. Thanks a lot.

Hi guys, I would like to know how to create a popup confirm message when trying to cancel a ticket. For example: If I try to change a ticket status for canceled I receive a popup message like this: Do you really want to cancel this ticket? Options: OK (Proceed with cancelation) No (Close pupup) Can you guys help me? Thanks in advance!

Hi Asan Jolison, Firstly, using Web Screen Painter you should create a column on Schema Designer, for example: z_desvio_processo as SREL – Boolean type Save and Publish. You need to stop SDM and run pdm_publish command. On order_status_changed.html you should insert a PDM_MACRO, for example: <PDM_MACRO name=dtlDropdown hdr="Desvio de Processo" attr=z_desvio_processo > Don’t forget to run pdm_webcache I hope it helps. Good luck

I can log into Servide Desk by this URL, but when I try to attach a file I receive the error. Sorry, I'm new on SDM how can I chek this communication that told? Thanks in advance

We are receiving the following error when trying to attach a file: __________________________________________________________________ Unable to connect to 'https://server:8443/CAisd/UploadServlet' Please make sure that the servlet path is correct, and that Tomcat is up and running. Would you like to retry? -------------------------------------------------------------------------------------------- I tried to set the ServLet path by, hostname, IP and URL and I receive the same error in all 3 options. Please look the screenshots Any assistance would be greatly appreciated. server05272014.xml