FOSSology

Should be fixed with svn 5836.

The problem was that some sql queries were incorrectly formed and not grabbing any information out of the database.

Tested on svn 5842 (on fo.usa) with same header/footer as previously mentioned. Here is the output.
1. the first link ($BROWSELINK ) is incorrect. The job id is 7476 not the upload_pk
2. $JOBQUEUELINK is ok
3. $SCHEDULERLOG doesn't appear to output anything
4. $UPLOADFOLDERNAME is ok
5. $DB.upload.upload_pk is supposed to output the upload_pk for this upload. Not all the upload_pk's in the system.
6. The footer has an extra garbage character at the end.

FOSSology scan has completed.

org.apache.aries.application-0.3.jar
http://fossology.usa.hp.com?mod=browse&upload=7476&show=detail

http://fossology.usa.hp.com?mod=showjobs&show=job&job=7476
bobg
upload.upload_pk[98 723 127 183 10 5 4 11 360 12 14 18 115 185 102 724 856 104 371 128 119 30 31 32 33 34 393 36 37 38 39 114 42 44 43 46 48 61 50 51 52 56 53 54 58 59 60 63 64 65 117 121 123 125 188 132 66 99 68 69 116 731 70 361 88 73 74 75 76 89 77 90 78 101 79 80 91 81 92 82 83 93 85 94 103 87 95 96 97 105 126 118 129 108 120 366 113 122 131 124 136 134 135 138 137 139 140 141 142 184 162 163 144 145 592 146 147 148 164 149 362 151 165 152 153 154 179 155 166 156 157 158 167 159 160 175 161 180 168 169 170 171 176 172 173 177 178 181 182 186 189 187 190 191 192 193 194 195 196 197 198 199 224 200 201 202 203 214 204 225 205 206 207 215 208 226 209 210 211 216 217 35 218 219 220 234 221 222 223 229 227 228 231 237 232 233 238 235 236 239 240 242 241 243 244 245 246 247 248 936 363 356 259 394 370 261 357 262 373 263 392 264 358 396 359 276 372 380 278 374 387 286 355 369 294 379 386 295 381 270 303 319 274 388 339 284 292 320 301 306 307 308 309 311 321 312 331 313 322 314
 315 316 594 250 251 260 364 317 277 323 318 305 375 395 324 382 332 325 389 333 326 334 327 335 328 336 329 337 454 338 340 342 341 344 343 345 346 348 347 349 350 351 352 353 354 257 266 368 268 399 269 272 378 273 280 282 283 288 252 253 265 365 290 267 397 291 279 297 299 281 376 300 287 254 255 289 256 258 296 383 367 298 271 398 304 390 275 310 285 377 293 400 302 384 391 401 402 409 595 403 404 407 405 412 406 408 410 413 411 414 415 416 417 466 418 419 530 420 440 596 421 450 746 455 725 441 423 424 726 727 425 442 456 427 443 430 431 444 432 451 433 445 434 457 435 436 437 438 439 446 452 447 448 453 449 458 461 459 467 462 463 465 464 468 470 469 471 521 472 531 473 532 533 474 495 534 475 535 620 476 496 550 477 478 479 480 481 497 482 483 484 498 485 511 486 487 499 488 489 490 500 491 492 493 512 494 501 502 513 503 519 504 505 514 506 522 507 508 520 509 510 515 516 517 518 523 524 536 525 526 527 528 529 537 585 538 597 586 539 556 589 540 598 587 541 542 557 
588 543 590 544 591 545 546 558 547 568 548 549 551 593 552 559 553 576 554 555 569 560 561 579 562 563 571 564 565 566 567 572 570 577 582 573 574 575 580 578 583 581 584 649 747 728 7 729 133 650 651 652 730 653 748 599 655 600 657 601 656 602 658 603 604 659 605 606 660 607 621 661 608 628 609 610 611 622 612 629 613 614 623 615 616 617 618 619 624 625 630 626 631 627 639 633 634 635 645 636 637 648 638 640 641 642 643 663 662 664 682 732 665 857 806 666 860 807 667 460 866 668 863 808 669 683 869 670 692 671 672 685 677 678 679 680 686 693 707 687 688 694 689 690 691 695 696 697 698 713 699 700 708 706 710 711 712 719 714 716 715 720 717 718 721 722 761 766 825 762 858 809 763 764 767 765 768 776 861 864 770 771 772 867 733 749 734 750 735 773 736 778 737 738 751 779 739 780 740 781 741 752 782 744 753 785 745 791 754 755 756 792 757 758 759 760 794 798 793 795 797 796 800 799 801 802 803 804 805 871 872 874 873 875 937 918 810 811 826 812 827 813 814 843 815 816 828 817
 829 818 830 819 831 820 832 821 822 833 859 834 844 824 849 835 836 57 837 838 839 845 840 841 842 846 847 848 850 853 851 852 855 862 854 865 868 870 877 878 901 879 913 876 880 881 902 882 914 883 884 903 885 917 886 887 904 888 889 890 905 891 915 892 893 906 894 916 895 896 907 897 898 908 899 900 920 909 910 911 912 921 922 927 919 923 924 925 926 928 929 930 931 932 933 934 935 978 970 939 938 947 971 940 972 941 948 942 973 943 949 979 944 954 974 945 975 976 946 950 977 951 955 980 952 981 953 956 968 986 249 984 983 958 969 959 985 987 960 988 961 989 962 963 964 965 990 966 991 967 992 993 1013 994 995 1010 996 1005 997 1007 1012 999 1011 1001 1000 998 1002 1003 1004 1006 1009 1008 1048 1014 1039 1016 1015 1040 1019 1018 1017 1020 1021 1022 1023 1024 1041 1042 1033 1026 1025 1027 1043 1050 1044 1028 1029 1030 1045 1031 1032 1034 1055 1035 1051 1036 1046 1037 1038 1056 1049 1052 1047 1053 1054 1057 1058 1059 1060 1061 1062 1081 1063 1064 1065 1082 1066 1083 1067 10
68 1069 1095 1070 1084 1071 1072 1073 1085 1074 1075 55 1076 1077 1078 1079 1086 1080 1096 1087 1097 1088 1089 1090 1091 1092 1093 1098 1094 1099 1100 1101 1102 1104 1103]

FOSSology
ÿ

This should be fixed with svn 5859

Tested in svn 5863

1) The $SUCCESS variable does not appear to work. Was it supposed to in this rev?
2) Only one email sent per job - excellent
3) Garbage text still in footer.
4) BROWSELINK is correct
5) JOBQUEUELINK may not be correct. Is there another variable for the Show Jobs page (http://fossology.usa.hp.com/?mod=showjobs&upload=1117) ?

tested on svn 5864
1) JOBQUEUELINK is correct now.
2) $SUCCESS is actually $JOBRESULT, which works
3) I forgot to mention in the previous note that $UPLOADFOLDERNAME also works.
The only problem is the garbage text in the footer. I don't feel this is critical to 2.0 so I'm closing this defect and filing a new one specifically for that garbage text.